From: Mike van Hoof Sent: 18 July 2006 12:18 > To: Addison, Mark > Subject: Re: Converting TEXT to BLOB with special chars > > Addison, Mark schreef: > > From: Mike van Hoof Sent: 18 July 2006 10:49 > > > Hello, > > I am having a problem, and am hoping this is > the wright list > to post to. > > I have a TEXT field with text in them (duh!)... > this text > also contains > special characters like é ß ü etc... > But when i convert the TEXT field to a BLOB > field these signs > are lost > and i get > > So does anyone know a workaround for this (and > not converting > to a BLOB > is not an option... sorry > > What version of mysql are you using? > > Version 4.1.12 > > What character set is the TEXT column? > > latin1_swedish_ci > > What are you using to display this text? > > PHP / HTML > > Although my guess is that the characters are not lost, it's just > that the software is now just getting binary (blob) data back > and doesn't know how to decode it. > If you convert the field back to TEXT can you see the > chars again? > > Yes i do...
Looks like the PHP will need to explicitly decode the data from mysql as latin1_swedish_ci before display. I don't know PHP but maybe someone else round here knows how... Are you sure you want to store text in a blob, seems to be making life hard for yourself? mark -- MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED] WWW.ITN.CO.UK Please Note: Any views or opinions are solely those of the author and do not necessarily represent those of Independent Television News Limited unless specifically stated. This email and any files attached are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] Please note that to ensure regulatory compliance and for the protection of our clients and business, we may monitor and read messages sent to and from our systems. Thank You. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]