insert Chinese chars using vb

  • Thread starter Thread starter m.tang
  • Start date Start date
M

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...
 
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 said:
Hi, I'm developing a stand alone program using VB accessing Ms Access
Click to expand...
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
Click to expand...
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
Click to expand...
help is very much appreciated. TQ
**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &
Click to expand...
ASP.NET resources...
 
Back
Top