Discussion Locked

Excel, ADO and BIG5 Chinese characters

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all,

I am using English Windows NT and have MingLiu font installed. I have excel file with Big5 Chinese data (displayed correctly in Chinese). I try to retrieve these informations using VB and ADO, but I got only ? symbol. What should i do to retrieve/display these Chinese characters using Visual Basic and ADO?

Thanks

5 replies

by fromnaija

VB stores strings as ASCII but Chinese and other Eastern Languages require UNICODE. So to display in VB you have to convert your string to UNICODE. Use the following code(or something like it, code over the top of my head so check).

NewString =StrConv(OldString, vbUnicode)

I hope this helps.

This discussion is closed to new replies.