\\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
[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
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
-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