Forums / Install & configuration / Database encoding name problem (koi8-r)

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&#322;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.

eZ debug

Timing: Jan 18 2025 04:23:54
Script start
Timing: Jan 18 2025 04:23:54
Module start 'content'
Timing: Jan 18 2025 04:23:56
Module end 'content'
Timing: Jan 18 2025 04:23:56
Script end

Main resources:

Total runtime1.3686 sec
Peak memory usage4,096.0000 KB
Database Queries215

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0061 587.8516180.8203
Module start 'content' 0.00611.2473 768.6719732.0156
Module end 'content' 1.25340.1151 1,500.6875340.4375
Script end 1.3685  1,841.1250 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00410.3024210.0002
Check MTime0.00150.1114210.0001
Mysql Total
Database connection0.00060.047510.0006
Mysqli_queries1.276493.26532150.0059
Looping result0.00220.15892130.0000
Template Total1.340998.020.6704
Template load0.00200.148920.0010
Template processing1.338897.825820.6694
Template load and register function0.00020.015310.0002
states
state_id_array0.00100.074810.0010
state_identifier_array0.00110.084020.0006
Override
Cache load0.00180.1338940.0000
Sytem overhead
Fetch class attribute can translate value0.00120.091060.0002
Fetch class attribute name0.00140.1007100.0001
XML
Image XML parsing0.00210.156060.0004
class_abstraction
Instantiating content class attribute0.00000.0016110.0000
General
dbfile0.00260.1876360.0001
String conversion0.00000.000330.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
8content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
23content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
3content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
16content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
3content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 55
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs