希望  高手看到了,帮我解决下。就是不知道 叶子在不在额。nvarchar2(50)像DB里面插入数据,  例如:准备数据是:50位(100000000000000000000000000000000000000000000000A)。DB里面 :  显示了49位,第50位的数据比你更没有显示

实际:100000000000000000000000000000000000000000000000预期:100000000000000000000000000000000000000000000000A
)是不是nvarchar2给预留了???急急急……叶子在不在呀???

解决方案 »

  1.   


    --帮你测了下,没这问题
    SQL> create table t(name nvarchar2(50));
    SQL> insert into t values('1000000000000000000000000000000000000000000000000A');
    SQL> select length(name),name from t;LENGTH(NAME)                                                                    
    ------------                                                                    
    NAME                                                                            
    --------------------------------------------------------------------------------
              50                                                                    
    1000000000000000000000000000000000000000000000000A  
      

  2.   


    3Q   ,刚刚  查出来啦,  我用的PLSQL软件有问题,用OB能正常显示额。╮(╯▽╰)╭    太假了……