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