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(a)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