MySQL Forums
Forum List  »  Russian

Upgrade to MySQL 5.0
Posted by: Andrei Toutoukine
Date: September 13, 2006 08:37AM

Dear MySQL users/developers,

After upgrading to MySQL 5.0 some php application (drupal CMS, see works a bit strange. All the content is in utf8 (russian) and is spread over different tables. Each table is managed by it's module and there is a DB abstraction layer.

I found a difference in a way clients (php application and mysql program) communicate the server. Namely character_set% variables!

mysql, which gives correct russian in utf8:
character_set_database and character_set_system are utf8, the rest are latin1.

php application with twice-encoded russian output:
everything is utf8! Isn't it correct?! Application sends data in utf8, MySQL server should not convert encodings and should operate on utf8 itself (character_set_connection and _server = utf8!) ?

Is there any explanations on character sets 'for dummies' (the MySQL manual confuses me)?

All the tables, database are "character set utf8"!

Edited 1 time(s). Last edit at 09/14/2006 03:39AM by Andrei Toutoukine.

Options: ReplyQuote

Written By
Upgrade to MySQL 5.0
September 13, 2006 08:37AM
September 14, 2006 09:02AM
October 04, 2006 04:30AM
March 04, 2008 04:59AM
May 05, 2008 03:17AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.