Solved

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

Posted on 2003-10-22
5
928 Views
Last Modified: 2008-02-01
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.
0
Comment
Question by:Buraque
5 Comments
 
LVL 1

Author Comment

by:Buraque
ID: 9604622
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...
0
 
LVL 3

Expert Comment

by:prady_21
ID: 9604894
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
0
 
LVL 17

Accepted Solution

by:
Squeebee earned 500 total points
ID: 9606256
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
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
understanding output of mysql version 2 62
No row return after calling the fillschema method 4 46
showing numeric numbers 2 38
CheckListBox usage 3 59
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question