Database encoding name problem (koi8-r)

Database encoding name problem (koi8-r)

Sunday 08 May 2005 12:32:04 pm - 7 replies

Modified on Sunday 08 May 2005 12:33:58 pm by Daniel Storin

Author Message

Ɓukasz Serwatka

Monday 09 May 2005 12:17:12 am

Hi Daniel,

Could you write more about your configuration? MySQL version, eZ publish, what language you have choosen, etc.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Daniel Storin

Monday 09 May 2005 5:59:35 am

I have use eZ publish installer for Windows 9x/NT/2000/XP - eZ publish 3.5.2
MySQL version 4.1.7-nt

I've chosen installation of Russian as primary language, and got error message :

"The database cannot be used, it uses the character set iso-8859-1 which is different from the requested charset koi8-r."

Then I changed the encoding of MySQL to the koi8r by using following commands:

alter database blog alter character set koi8r;
alter database blog collate koi8r_general_ci;

And then I got the message that I posted before.

Thanks!

Miłosz Chmielewski

Monday 09 May 2005 6:08:24 am

I have a similar problem. I have chosen polish as default language.

"The database cannot be used, it uses the character set ISO-8859-1 which is different from the requested charset ISO-8859-2."

my system configuration:

URL - http://x.x.x.x:8085/plain
Admin URL - http://x.x.x.x:8085/plain_admin
Access type - url
Access value - plain
Functionality - contact_us, files, forum, gallery, links, media, news, poll

Webserver info:
Version - Apache/1.3.33 (Unix) PHP/4.3.9

PHP info:
Version - 4.3.9

OS info
Name - Linux bolta1 2.4.26-sns-1.8 #1 SMP Thu Sep 23 05:14:11 EEST 2004 i686
CPU Type - Pentium III (Coppermine)
CPU Speed - 797.979 MHz
Memory Size - 525135872 (500.81 MB)

Database info:
Type - MySQL (4.0.24-debian-5-log)
Driver - ezmysql

Email info:
Transport - SMTP

Critical tests

directory_permissions - Success
phpversion - Success
database_extensions - Success
image_conversion - Success
open_basedir - Success
safe_mode - Success
memory_limit - Success

execution_time - Success
magic_quotes_runtime - Success
accept_path_info - Success
php_session - Success
file_upload - Success

Other tests:

php_magicquotes - Failure
zlib_extension - Success
mbstring_extension - Success
imagegd_extension - Failure
imagemagick_program - Success
database_all_extensions - Failure
php_register_globals - Success
texttoimage_functions - Failure

Thank you for help !
Dzieki !

Jan Borsodi

Monday 09 May 2005 7:12:29 am

Regarding:
<i>"The database cannot be used, it uses the character set iso-8859-1 which is different from the requested charset koi8-r."|</i>

This happens because eZ publish doesn't recognize the <i>koi8r</i> alias and thus sees the two as different charset.
I'll make sure this is recognised for the next eZ publish releases.
If you want to get it work ASAP you can edit <i>lib/ezi18n/classes/ezcharsetinfo.php</i> and add:

'koi8r' => 'koi8-r',

right after the existing entry:

'koi-8-r' => 'koi8-r',

I've also made a bug report on this issue:
http://ez.no/bugs/view/6608

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

Jan Borsodi

Monday 09 May 2005 7:18:13 am

Regarding:
<i>"The database cannot be used, it uses the character set ISO-8859-1 which is different from the requested charset ISO-8859-2."</i>

This means that you will have to change the character set on your database before it can be used by eZ publish with your current language choice.

You can fix this by running:

alter database xyz character set latin1;

Where <i>xyz</i> is the name of your database.

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

Daniel Storin

Monday 09 May 2005 1:21:54 pm

Thank you, Jan - its work!

Keratox

Saturday 26 November 2005 9:56:22 am

I've this

The database cannot be used, it uses the character set iso-8859-1 which is different from the requested charset iso-8859-15.

in this case what i have to modify ??

http://www.keratox.net
http://forum.keratox.net

I'm not enough young to know everything.

You must be logged in to post messages in this topic!

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.