Forums / Developer / How to convert data from KOI-8 to UTF-8

How to convert data from KOI-8 to UTF-8

Author Message

Vytautas Germanavičius

Tuesday 19 October 2004 4:29:29 am

I made site with EZ 3.3.3. Site is in russian. Instaler set encoding to KOI-8. So all data in site are entered using that encoding.
Now i would like to add data in lithuanian (encoding iso8859-13 or UTF-8).
But how to convert all data from old database to new?

{set-block scope=root variable=cache_ttl}0{/set-block}

Björn Dieding@xrow.de

Wednesday 20 October 2004 2:30:12 am

My guess:
I think if you are using mysql you can do this by upgrading to Mysql 4.1.X.

There are comando line scripts shipped with mysql to convert dbs into other charset.

Check the mysql docs.

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Mikhail Chekanov

Wednesday 20 October 2004 3:25:50 am

For Mysql:
1. Dump the database to file and convert it to UTF with iconv.
2. Replace all occurrences of "KOI-8" in this file with "UTF-8"
3. reCreate db from dump :)
But: latest beta of MySQL 4.1 has a bug - http://www.ez.no/community/bug_reports/mysql_error_1071_with_utf8_db_on_kernel_injection
so you should use iso8859-13
Does it support cyrillic charcters?

--
mike
#6595551

Vytautas Germanavičius

Wednesday 20 October 2004 6:42:01 am

I think, this was reason, why site with converted data did not work fo me.
Does EZ 3.4.1 use different from 3.3.3 db structure ?

iso-8859-13 is contains latin and baltic character sets.
only UTF-8 encoding has both character sets lithuanian and russian

Another question, is any way to export from 3.3.3 and import to 3.4.1 only MY entered data without EZ system data?

{set-block scope=root variable=cache_ttl}0{/set-block}

Mikhail Chekanov

Thursday 21 October 2004 3:22:08 am

>Does EZ 3.4.1 use different from 3.3.3 db structure ?
Yes. Not entirely different, though not exactly the same.

Another question, is any way to export from 3.3.3 and import to 3.4.1 only MY entered data without EZ system data?
Yes. Look for upgrade scripts in /update/database/mysql/

--
mike
#6595551