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

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}

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

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