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
(prod_title,prod_published,prod_pub_prod_id,prod_content_info,prod_samp_doc,prod_toc_doc,prod_type,prod_ready,prod_discont,prod_info_type,prod_id,prod_num,pub_id,prod_added,prod_updated,prod_export,prod_changed)
VALUES ('Disposable Paper Products ? Uruguay','2007-12-01','DPP2007UY','Pages:
44','\\\\xa20\\d\\publishers\\eo\\fullreports\\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'
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).
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
