converting some rows from utf-8 to iso-8859-1
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
|