Re: Correct charset/locale settings?

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


--
Horde i18n mailing list - Join the hunt: http://horde.org/bounties/
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: [email protected]