[Phpmyadmin-devel] japanese-sjis SQL-parser error

[Robin Johnson]

On Mon, Sep 23, 2002 at 03:38:24PM +0900, luc wrote:
> Hi list
> 
> japanese sjis word error by SQL-parser.
> Some letters include '0x5c' code same backslash.
> 
> I can not execute below SQL
> INSERT INTO kanji2 VALUES (1, '...0x955c');
Hi Luc.

I don't know how you are generating the SQL in question, but when I type
in the U+955C [as alt-38236] (which is \) character into my browser, windows seems to fault and generates a U+005C character instead of the U+955C that I typed in. However if use character map to generate the character, and then copy paste to PMA, the SQL it generates is 
INSERT INTO `foo` ( `a` ) 
VALUES (
'镜'
);

Which is perfectly fine for my case of limited japanese, but I don't
know if that is the solution for a lot of CJK content.

> error session is :
> eNqFkU8vA0EYh+/zKd6DBMl27My21Y7TZrOhsd2t3e1WEEnRVKua1UrD0Y4LQgi9+BKcJA7+JEgc
> +Aw+gYNv4F0uTuY0yczzzPub+dm+7/kCLAYWB8d2BRR0KDDIZ3UShHgiCbGiQMBIaU1Af6sT13v9
> Ro92Wis0Xo8NbQCM8kngus4n9OIEKwLLi5wuDA6dxmYR7J0YRkh5N5hzBBiUGzTHM91tUg188AIN
> zGnbDTWIbJxVa3Wh7C2UHMeEHNVJpWwK4NSgLNNb5aQyU0k5zcM4WYr7UCu5bkgc050W0K5n+u1W
> n/wMKrmB7Ye4hB5s1LvtFofIdKp2AGNMg9Hh0uHDyaVsyHnZHC6Njk+RfwSOguzIFdlEvLK3KAcX
> KsVIFUuey2XEf1VLuqgP5LE8UMhZlJ/unhk3FGAunTIvl/HuIxnhpKZCyKfCz6MV4CSCB+/nqwqs
> gFjymnwlL8n93owCLiJ883jzosCYnoaM8TURBm3gH6rCMvZbEJaTVFUs/8Oq6bTHs9PP2eN9FZmW
> 9nr1fHd7/faB7DdP8v3z
Decoded bug report (the characters are badly mangled by my mail client):
ERROR: C1 C2 LEN: 80 81 640
STR: .

CVS: $Id: sqlparser.lib.php3,v 1.27 2002/09/19 16:50:32 lem9 Exp $
MySQL: 3.23.52-nt
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.3.1-rc2
PHP VER,OS: 4.2.3 WINNT
LANG: ja-sjis
SQL: INSERT INTO kanji2 VALUES (1, '.\.¿...e.X.g.\');
INSERT INTO kanji2 VALUES (2, '.l.b.g.X.P[.v.\');
INSERT INTO kanji2 VALUES (3, '.C...^[.l.b.g.C.N.X.v...');
INSERT INTO kanji2 VALUES (4, 'ýÄ123');
INSERT INTO kanji2 VALUES (5, '.X.^.C...V[.g');
INSERT INTO kanji2 VALUES (6, '.e.X.g');
INSERT INTO kanji2 VALUES (7, '.Í.c');
INSERT INTO kanji2 VALUES (8, '.È.ñ.Å.¾H');
INSERT INTO kanji2 VALUES (9, '¶À¶Å');
INSERT INTO kanji2 VALUES (10, '.p[.V.X.e...g');
INSERT INTO kanji2 VALUES (11, '.l.X.P.U');
INSERT INTO kanji2 VALUES (12, '.l.X.P.U.U');
INSERT INTO kanji2 VALUES (13, '.íK.');
INSERT INTO kanji2 VALUES (14, 'ȯĽ¹°Ìß');

-- 
Robin Hugh Johnson
E-Mail     : robbat2 at orbis-terrarum.net
Home Page  : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ#       : 30269588 or 41961639
GnuPG FP   : 11AC BA4F 4778 E3F6 E4ED  F38E B27B 944E 3488 4E85
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 232 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20020923/bcd2f169/attachment.sig>