[i18n] Correct charset/locale settings?

[Tornoci Laszlo]

Joonas Hämäläinen wrote:
> Hips,
> 
> I was asking similar question in horde mailing list yesterday, but was 
> directed to search i18n list. I didn't find answers via search, so I'll 
> rephrase my question a bit and ask again. :)
> 
> I have multinational horde installation, running old horde version. I am 
>  in need to update it into current version, and of course keep old data 
> for users.
> 
> So, very hard bottom question is what character settings I should use in 
> horde? It seems to default in utf8, but if I take old db and upgrade it 
> for new version, there are entries which doesn't look correct.
> 
> Old system has latin1_swedish_ci collation. Server itself has 
> en_US.UTF-8 locale. That old horde doesn't have such charset setting.

A simple conversion provided by mysql is not good, because the db 
entries are php serialized arrays, and a conversion is likely to change 
the lengths of the strings as well. Some script needs to be written for 
this purpose. I would be very happy to see some good soul to write and 
publish such a script with a short clear guide how to use it. I guess it 
is not too difficult to do this, I just don't know enough php.


					Yours: Laszlo