Posted by Jerry Stuckle on 03/16/07 10:51

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('琵')
>

Interesting. What is your table definition and what charset are you
using? Also, what is the hex value of '琵'?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: folder and file permissions to read and write images
• Prev in forum: Re: Query inconsistency (MySQL vs PHP) -> DATE_FORMAT
• Thread view: Re: what's wrong?

[Reply to this message]