I am working on a project that requires to insert simplified Chinese chars to tables in MS SQL Server v7.
Have no problem to log onto the server with the following connection:
jdbc:jtds:sqlserver://192.168.0.3:1433/armcodatadevice (of course along with
username and password)
but the records inserted are bunch of ???s, which should've been Chinese chars.
Then I learned that I should specify character set and encoding. So I did the following:
jdbc:jtds:sqlserver://192.168.0.3:1433/armcodatadevice?useUnicode=true&character
Encoding=UTF8 (with the same username and password)
This time I cannot even logon to the server. I got the following error msg:
java.sql.SQLException: Cannot open database requested in login 'armcodatadevice?useUnicode=true&characterEncoding=UTF8'. Login fails.
Could anyone please tell me where I did wrong?
Thanks,