nvarchar(100) 最大的中文字符数是100
varchar(100) 最大的中文字符数是50

解决方案 »

  1.   

    create table #t (n nvarchar(100))
    insert into #t values('中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中')
    select * from #t结果如下:(所影响的行数为 1 行)n                                                                                                    
    ---------------------------------------------------------------------------------------------------- 
    中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中(所影响的行数为 1 行)
      

  2.   

    好像在java程序中用jdbc-odbc连数据库是不满100的