| 
	
 | 
 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
 
  
Navigation:
[Reply to this message] 
 |