Database encoding name problem (koi8-r)

«

Previous topic

|

Install & configuration

|

Next topic

»

Author	Message
Daniel Storin	Sunday 08 May 2005 12:32:04 pm During the installation I received this message: "The database cannot be used, it uses the character set <b>koi8r</b> which is different from the requested charset <b>koi8-r</b>." I think this is same encoding, but the names are different. How can I fix it? Thanks, and excuse me for my English.
Ł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.

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

eZ debug

Timing:	Jan 18 2025 11:17:53
Script start
Timing:	Jan 18 2025 11:17:53
Module start 'layout'
Timing:	Jan 18 2025 11:17:53
Module start 'content'
Timing:	Jan 18 2025 11:17:53
Module end 'content'
Timing:	Jan 18 2025 11:17:53
Script end

Main resources:

Total runtime	0.0135 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0048	589.4688	152.6406
Module start 'layout'	0.0048	0.0027	742.1094	39.4922
Module start 'content'	0.0075	0.0041	781.6016	97.4922
Module end 'content'	0.0117	0.0018	879.0938	42.3047
Script end	0.0134		921.3984

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0022	16.3739	14	0.0002
Check MTime	0.0010	7.4432	14	0.0001
Mysql Total
Database connection	0.0009	6.4532	1	0.0009
Mysqli_queries	0.0026	19.2605	3	0.0009
Looping result	0.0000	0.1417	1	0.0000
Template Total	0.0014	10.6	1	0.0014
Template load	0.0008	6.1663	1	0.0008
Template processing	0.0006	4.3901	1	0.0006
Override
Cache load	0.0006	4.4273	1	0.0006
General
dbfile	0.0002	1.6912	8	0.0000
String conversion	0.0000	0.0567	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs