Chinese character save and display

[vijay]

My application is to show and retrieve the Chinese character. I am using VB 6.0 as front end and SQL server 2000 as back-end. I am connecting to the database through Data source Name using RDO 2.0 connection object and viewing through the RDOResultset object. Any chinese character entered in the textbox of the Front-end should be saved and should be shown in Chinese character. My OS is Windows 2000 server English version. I have set all the regional settings and related locale settings. I am able to enter the Chinese character, but as the data is saved, it will be saved as ???? and if viewed through the Front-end, ??? is shown. when the connection is replaced ADO, it works fine and data saves as some special characters but shown as Chinese character from the Front -end. But I need in RDO, since the English version the Project is running in one of the customer place, and I don't want to make seperate copy for Chinese by changing in source codes.

Hey Guys this is a challaging work I suppose, and I know u guys be able to solve this issue. Pls let me know any clarifications required.

Thanks and Regards,
Vijay

[Robert Wellock]

Sounds hard but have you checked in the Unicode character encoding.

[vijay]

Where , the Unicode has to be set????