yep, thru php it's easy: just do a utf8_decode($value). but is it
possible directly from the mysql command line.
On 31/08/2007, Ken Peng <[EMAIL PROTECTED]> wrote:
>
> On Thu, 30 Aug 2007 11:41:14 +0200, "Olav Mørkrid"
> <[EMAIL PROTECTED]> said:
> > if a table column is supposed to contain text i
On Thu, 30 Aug 2007 11:41:14 +0200, "Olav Mørkrid"
<[EMAIL PROTECTED]> 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
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;
