f-x.p@laposte.net wrote:
> Hi,
>
> One of my table got messed up on the "title" column.
>
> For example the french word "frère" is now written as "frère".
>
> I guess what happened was:
>
> 1) select convert(_latin1 "frère" using utf8)
> --> frère
> 2) select convert(_latin1 "frère" using utf8)
> --> frères
>
> My problem is that I couldn't get it backward by doing :
>
> select convert(_utf8 "frère" using latin1)
>
> because it still ends up with the same result: frères
>
> Can someone help me with this, and maybe give me the command to change
> the whole "title" column.
>
> Thank you very much for any help
>
> François
>

can you with certainty say what happened? also let us know your current
encoding on the table and current collation on its columns? also let us
know what you want it converted to.