f-x.p@laposte.net wrote:
> Hi,
>
> Sorry Jaochim, you are right in the fact that an easy update won't
> work for german, but I think you missed the point of making a
> **double** conversion.
>
> What the table below shows is that there is an easy rule for small
> letter with an ¨ (umlaut), but no rule for capital letters nor for ß.
>
>
> Capitals:
> A A A
> E E E
> I I I
> O O O
> U U U
>
> small:
> a a a
> e e e
> i i i
> o o o
> u u u
>
> Capital¨:
> Ä Ã„ Ä
> Ë Ã‹ Ë
> Ï Ã Ï
> Ö Ã– Ö
> Ü Ãœ Ãœ
>
> small¨:
> ä ä ä
> ë ë ë
> ï ï ï
> ö ö ö
> ü ü ü
>
> ss:
> ß ÃŸ ß
>
> Sincerely
>
> François


Francois,

to repair a table's character set and/or collation, there is an option
for myisamchk that you can run on the table at the file level. it looks
something like this:

myisamchk --set-collation=utf8_bin


--
lark -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".