Error converting characters into server's characte

 

hibernate使用sybase 15.0数据库，在未设置好DB参数时可能会造成乱码，出错显示如下：
Error 500: Hibernate flushing: Could not execute JDBC batch update; SQL [insert into CCS_LOG_ACTION (OP_ID, OP_TIME, MAINTYPE_CODE, SUBTYPE_CODE, SECONDTYPE_CODE, DESCRIPTION, DATALINE, BP_TYPE, BIZ_CODE, BIZ_ID, WORKSHEET_ID, WORKSHEET_NO, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; JZ0BE: BatchUpdateException:鎵ц鎵瑰鐞嗚鍙ユ椂鍑洪敊:Error converting characters into server's character set. Some character(s) could not be converted. ; nested exception is com.sybase.jdbc3.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException:鎵ц鎵瑰鐞嗚鍙ユ椂鍑洪敊:Error converting characters into server's character set. Some character(s) could not be converted.

解决办法：
sp_configure "disable character set conversions" ,1
"disable character set conversions"为静态数据，需要重启server。那先shutdown数据库，然后再./startserver -f servername

 

昨日帮同事安装LoadRunner9.1，把依赖（或可能需要）的组件都装上后，仍出现“command line option syntax error.type command /? for help”  错误，google一下，竟然跟很多SQLServer数据库安装出错的提示一样，可见http://www.918x.cn/post/679.html：

寻寻觅觅，终于还是在微软站点找到答案。是这样说的：
This problem may occur if all the following conditions are true: 
• You run the SQL Server 2000 SP3 Setup.bat file from a folder that contains double-byte character set (DBCS) characters in the folder name. 
• An ODBC client program that uses the Sqlsrv32.dll file is running on your computer.
我英文很烂，不过还是勉强看明白了。其中第一点是说，如果你把安装文件放在一个拥有双字节的名字的文件夹里就活该倒大霉。我的SQL SERVER2000安装盘的所在文件夹起了个中文名字，而汉字正是所谓的双字节。将文件夹名字改回英文再装，问题解决了。