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

On Thu, 30 Aug 2007 11:41:14 +0200, "Olav Mørkrid" <olav.morkrid@gmail.com> said:
> 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;
>

I don't know if mysql has this charset converting routine. But you can do it by application scripts,ie,in perl you can convert them by,

use Encode;
my $iso_str = encode('iso-8859-1',decode('utf8',$utf8_str));

first you select utf8 string from db one by one and store it to $utf8_str,then use the function above to be converted to iso-8859-1,then insert it again to mysql.

-- 
  Ken Peng
  kenpeng@fastmail.fm

-- 
http://www.fastmail.fm - Accessible with your email software
                          or over the web


-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com