Re: [Koha-devel] Sharing experience with utf-8

[Paul POULAIN]

Tumer Garip a écrit :
> Here is what we had to do to use koha in utf-8 hoping that it helps in 
> some of your discussions:

Hi Tumer,

I investigate UTF-8 move for the next 3.0 version. I experience a little
problem :

> 4-       We changed the character set of the database to utf-8 with the 
> iso-xxxx data in it. No problem for Mysql as you are moving up the 
> ladder. No need to reload the data (10 min)

I already am in mysql 4.1, with iso8859 database collation.
If I change a table and column type to utf8, all datas already in the DB
are not modified.
any data entered is correctly in utf8

What step did you exactly follow to get a utf8 database ?

I see a solution here :
http://dev.mysql.com/doc/refman/4.1/en/charset-conversion.html

but it's really a pain.

There is another possibility, with :
* mysqldump
* iconv on dump
* mysql reload

Could you describe a little bit more what you did ?
--
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)