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


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.
Who is Participating?
SqueebeeConnect With a Mentor Commented:
You could always just designate the column's character set to the Japanese one, in which case you should have less problems:
BuraqueAuthor 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...
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.