Chinese Character in SQL 2000

[Franklin LO]

Hi,

I know someone has asked similar question but the solution in this forum seems
can't help me. I am now using SQL 2000 (ENG version) and ColdFusion MX7. I have
made a form by Dreamweaver in Chinese which has been set to use "big-5". The
page can been displayed and can be submitted without problem. However, I found
the chinese character were all "???" in the database. I have tried using
SQL_Latin1_General and Chinese_Taiwai_Stroke as the collation but no use. I
have change the Regional settings to Chinese in my WIndows 2000 Server but the
problem presists. I have even checked the option "Enable Unicode for data
sources configured for non-Latin characters" in Admin page of ColdFusion.
Please tell me how can the problem be solved. Thanks

[PaulH]

if possible, i would suggest that you use unicode (utf-8) instead of big-5.

just to confirm, you're using the JDBC driver and not the ODBC one? how are
you defining the columns holding your text? are these nvarchar/nchar/ntext? as
for your cf code, have a look at
[url]http://www.sustainablegis.com/unicode/greekTest.cfm[/url].