Posted by Heiko Richler on 03/16/07 08:09

Man-wai Chang wrote:
> insert into canton ( big5, thekey, changjei, canton, touched ) values ('
> 琵\','BAY ','MGPP ','PEI ',0)
>
> You have an error in your SQL syntax; check the manual that corresponds
> to your MySQL server version for the right syntax to use near 'BAY
> ','MGPP
>
> '琵\' is mysql_real_escape_string('琵')

'琵\' is strange! Did you try replacing it by anything else? \' May not
be seen as the end of the string. There would be a string " 琵',"
followed by BAY...

FUp2: comp.databases.mysql

Heiko
--
http://portal.richler.de/ Namensportal zu Richler
http://www.richler.de/ Heiko Richler: Computer - Know How!
http://www.richler.info/ private Homepage

[Back to original message]