insert Chinese chars using vb

[m.tang]

Hi, I'm developing a stand alone program using VB accessing Ms Access database. I use NJStar to key in Chinese characters into the system. But I found that certain characters are not able to write into the db as it hits "Syntax error in string query expression - "¯QÀs°|" when I use sql statement - insert...

¯QÀs°| is the chinese chars. I have done a few testing and found out that the "|" is not invalid in sql statement and also a few chars like "(", ")". I tried all the chinese char font type but it seems like it doesn't work at all. For your info, I am in Window XP platform.

Anyone who have any knowledge or experience in it, mind to share. Your help is very much appreciated. TQ

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

[Paul Fredlein]

Hi,

Sorry, no help as such. But I did a similar thing on the Mac using RealBasic
(not an Access db thought) and had no hassles. RealBasic handled the
chinese, both traditional and simplifed as strings. Maybe you need a unicode
string or something.

Paul

"ping" <m.****@mailcity.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Hi, I'm developing a stand alone program using VB accessing Ms Access database. I use NJStar to key in Chinese characters into the system. But I
found that certain characters are not able to write into the db as it hits
"Syntax error in string query expression - "¯QÀs°|" when I use sql
statement - insert...
¯QÀs°| is the chinese chars. I have done a few testing and found out that the "|" is not invalid in sql statement and also a few chars like "(", ")".
I tried all the chinese char font type but it seems like it doesn't work at
all. For your info, I am in Window XP platform.
Anyone who have any knowledge or experience in it, mind to share. Your help is very much appreciated. TQ
************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &

ASP.NET resources...