Insert Japanese characters into MySQL database. I have to use "backslash" after Some "Kanji" symbols but which ones ??

Buraque
Buraque used Ask the Experts™
on
Hi,

I am trying to insert some Japanese text into a MySQL database. My code and everything is working just fine, but I found that I have to put "backslash" after some of "kanji" symbols because some of them seems to have "backslash" and "semicolon" in their second bytes. To avoid character transformation, I have to use escape symbol "backslash" after that symbol.

I need to find a list of kanji symbols which backslash have to be used... Or some kind of javascript / vbscript / ASP code that reveals the second byte of a double-byte character...

Any help will be appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Well, I have made a further search on the net and I found that I need PHP's  [ addslashes(string) ]   equivalent of ASP or MySQL...

Commented:
As long as i know, you need not do anything like adding backslashes in front of kanjis
If  the column is binary, where the Japanese characters will be stored, i think it should work

if you can tell more abt the errors, i think it should help
Top Expert 2004
Commented:
You could always just designate the column's character set to the Japanese one, in which case you should have less problems:

http://www.mysql.com/doc/en/Charset.html

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial