Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Unable to display NVARCHAR correctly in VB6

Author  Topic 

hiuhiu
Starting Member

18 Posts

Posted - 2005-05-26 : 04:13:52
Hi,

I'm using VB6 with SQL Server 2000 as backend. One of the fields in a table is set to NVARCHAR. If I use SQL Query Analyzer to update and retrieve the records with Chinese characters, everything displays OK. However, when I retrieve the field in the VB client, it will only show garbage instead of Chinese characters.

I have tried it on a PC with Chinese NT, it displays the Chinese characters without problem. According to MSDN, VB stores the data in UNICODE so how come I can't display the Chinese characters correctly in English Windows?

Any help will be appreciated!

raclede
Posting Yak Master

180 Posts

Posted - 2005-05-26 : 04:43:22
check this out
http://www.cyberactivex.com/UnicodeTutorialVb.htm

"If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year, killing everyone inside. "

raclede™
Go to Top of Page
   

- Advertisement -