Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Jerry Schwartz (jschwartzthe-infoshop.com)
Date: Wed Apr 16 2008 - 11:49:03 CDT
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 this error message from my application:
ERROR: INSERT INTO prod
VALUES ('Disposable Paper Products ? Uruguay','2007-12-01','DPP2007UY','Pages:
Incorrect string value: '\x96 Urug...' for column 'prod_title' at row 1
That bizarre character in the middle of 'Disposable Paper Products ? Uruguay'
is, as you can see, \x96. MySQL certainly doesn't seem to like it. The data is
being read from a file. Curiously, if I copy the line directly from the input
file it looks like this:
Disposable Paper Products - Uruguay
You may not be able to see it, but that is actually an n-dash (\x96).
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql