Notes on Reference Citations - Version 2.71, by Dr. Herong Yang
Delphi 2010 "£" sign issues and Parameters
'Sending Non-ASCII Text to MySQL in Latin1 Encoding' tutorial was cited in a forum post in 2009.
The Sending Non-ASCII Text to MySQL in Latin1 Encoding tutorial was cited in a forum post in 2009.
Subject: Delphi 2010 "£" sign issues and Parameters Date: Nov 19, 2009 Author: karl pritchett Source: https://forums.embarcadero.com/thread.jspa;?messageID=183417 >Never used MySql, but that all works fine in MS SQLServer +d2010 >(used ado, adocommand for insert/update, adodatasource for query in >a test) Anything strange picked for the db collations or other >settings etc? Updated D2010 with the latest fixes ... Swedish collation? I'd guess that's where the problem is - ansi £ mapped to whatever that is in the swedish character set This might be of use http://www.herongyang.com/PHP-Chinese /PHP-MySQL-Sending-Non-ASCII-Text-Latin1.html It covers some of the same problems with foreign char sets
Table of Contents