How to insert non-Unicode CJK string to SQL with DBLIB if SQL default 
Author Message
 How to insert non-Unicode CJK string to SQL with DBLIB if SQL default

If the SQL's default language (set up in the installation) is CJK, there
is no problem to insert ANSI CJK string.

However, when the SQL default language is English (non-CJK), I can
insert ANSI CJK string with the Query Analyzer,
but if I use DBLibrary to do so, the data becomes garbage.

(It looks conversion has been taken place. I guess SQL server
(server-side) instead of the DBLibrary (client-side) doing the
conversion with the default English collate. So isn't even if the symbol
'N' is NOT added, SQL always encodes non-unicode string to it target
non-Unicode table?)

I've used DBSETLAPP(login, "Traditional Chinese") to set to the CJK
session collate but it didn't help.

I tried all the combination of the 2 options ("Using international
setting" and "Automatic ANSI to OEM conversion") in "Clinet Network
Utility" but It still didn't help!

So is there any way to change the default session collate setting to my
target collate with DBLIB in order to insert ANSI CJK string into SQL?

System Configuration:
  SQL Server 2000 installed with English collate.
  Create a table having columns of either VCHAR or CHAR inside a
CJK-collate database.

Your kind help is appreciated!

Sat, 12 Aug 2006 06:11:06 GMT
 [ 1 post ] 

 Relevant Pages 

1. How to insert non-Unicode CJK string to SQL with DBLIB if SQL default collate is non-CJK?

2. insert unicode string becomes ?????? in sql server

3. Problem to Insert CJK Data Stream into English SQL Server

4. problem about unicode and cjk???

5. upgrade from sql server 6.5 to sql 2000 non-default instance

6. Problem in Writing Non-Unicode string in CDaoRecordset

7. Specifying Non-Unicode Character Set during remote install of SQL 7 on Win2kPro

8. unicode vs. non-unicode

9. Creating non-unicode database in Sql Server 2000.

10. Need to upgrade a non-unicode database to unicode database

11. Conversion Unicode database to a non-Unicode

12. Help: MS SQL Insert not showing default MS SQL values

Powered by phpBB® Forum Software