> Can somebody throw light on this?
>
> Since the Jap characters may not come up in this forum html pages...
> I have put GIF and txt files on following link. These pages will show u
the
> intended Jap characters and the actual characters coming up on html page
> Please visit following links to view the pages, and do provide some
> information regarding this behavior
> http://www.emantratech.com/jap_text/japanese-text-problem.htm
> http://www.emantratech.com/jap_text/event3731.gif
>
> Haresh Gujarathi

Hi, Haresh.

x8868(UTF-16) = x955C(SJIS)
x73FE(UTF-16) = x8CBB(SJIS)

Some of Shift-Jis character contains code '5C' in its second byte.
You know, code '5C' is the escape-character(\).
When MySQL reads your SQL syntax, escape-character(5C) and next one
character
will be ignored(removed). Then your SQL syntax gets corrupted.
So, You need to insert '5C' just after the '5C' in your syntax.
Double escape-character(\\) means single character'\'.

Or, modify my.ini file to set 'default-character-set=sjis',
and make it sure 'mysql>status' command describes
'default-character-set=sjis'.

regards

Osamu Shimono