\x96 in column value?

2008-04-16 Thread Jerry Schwartz
\\DPP07_UY.pdf','xa20\\d\\publishers\\eo\\content\\DPP07_UY-LOC.doc','S',1,0,'E','Y8F1kqasoQVE90F',65642,'BG3g33kv5CDkim7',NOW(),NOW(),1,1); Incorrect string value: '\x96 Urug...' for column 'prod_title' at row 1 That bizarre character in the middle of 'Disposable Paper Products ? Uruguay

RE: \x96 in column value?

2008-04-16 Thread Jerry Schwartz
[mailto:[EMAIL PROTECTED] Sent: Wednesday, April 16, 2008 12:49 PM To: 'Mysql' Subject: \x96 in column value? Why is the character \x96 not allowed as a value in an INSERT query? I've SET NAMES utf8, the table collation is utf8_general_ci, the default character set for the table is utf8. I get

RE: \x96 in column value?

2008-04-16 Thread Tim McDaniel
On Wed, 16 Apr 2008, Jerry Schwartz [EMAIL PROTECTED] wrote: I'm running afoul of the UTF8 character set somehow: mysql select convert(char(0x96) using utf8); +--+ | convert(char(0x96) using utf8) | +--+ | NULL

RE: \x96 in column value?

2008-04-16 Thread Jerry Schwartz
-Original Message- From: Tim McDaniel [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 16, 2008 2:32 PM Cc: 'Mysql' Subject: RE: \x96 in column value? On Wed, 16 Apr 2008, Jerry Schwartz [EMAIL PROTECTED] wrote: I'm running afoul of the UTF8 character set somehow: mysql select convert