各位大虾;
我在利用odbc方式查询sybase数据库时,如果查询语句where中参数带有中文,
像 select * from bas_vendor_master where vendor_name='陆员集团' 这样的语句就会报错。System.Data.Odbc.OdbcException: ERROR [01004] [MERANT][ODBC Sybase ASE driver]String data translation caused data truncation.ERROR [HY000] [MERANT][ODBC Sybase ASE driver][SQL Server]Unclosed quote before the character string '緩歸本體'.ERROR [42000] [MERANT][ODBC Sybase ASE driver][SQL Server]Incorrect syntax near '緩歸本體'.请各位帮忙解决,谢谢!
我在利用odbc方式查询sybase数据库时,如果查询语句where中参数带有中文,
像 select * from bas_vendor_master where vendor_name='陆员集团' 这样的语句就会报错。System.Data.Odbc.OdbcException: ERROR [01004] [MERANT][ODBC Sybase ASE driver]String data translation caused data truncation.ERROR [HY000] [MERANT][ODBC Sybase ASE driver][SQL Server]Unclosed quote before the character string '緩歸本體'.ERROR [42000] [MERANT][ODBC Sybase ASE driver][SQL Server]Incorrect syntax near '緩歸本體'.请各位帮忙解决,谢谢!
command.Parameters.AddWithValue("name","陆员集团")
另外,你楼数错了,我是1楼绿色辅助工具——《Csdn收音机》帮你轻松掌握Csdn最新动向!