Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

converting some rows from utf-8 to iso-8859-1

From: Olav Mørkrid <olav.morkrid(at)gmail.com>
Date: Thu Aug 30 2007 - 05:41:14 EDT


if a table column is supposed to contain text in iso-8859-1, but utf-8 encoding have snuck in on a few rows by mistake, how are these rows converted into iso-8859-1?

what i am looking for is something like this:

update mytable set mycolumn = utf8toiso88591(mycolumn) where id between 500 and 600;

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com
Received on Thu Aug 30 06:44:57 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:08:05 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library