Huge bug with MYSQL!!

Stephan_Craft · 04-06-2009, 02:33 AM

I discovered this:

PHP Code:



| collation_connection            | latin1_swedish_ci                        |
| collation_database              | latin1_swedish_ci                        |
| collation_server                | latin1_swedish_ci

swedish_ci? I need russian! i think all my problems is becose of this now... How to fix it?

TB0ne · 04-06-2009, 07:17 PM

Quote:

Originally Posted by Stephan_Craft

I discovered this:

PHP Code:



| collation_connection            | latin1_swedish_ci                        | 
| collation_database              | latin1_swedish_ci                        | 
| collation_server                | latin1_swedish_ci

swedish_ci? I need russian! i think all my problems is becose of this now... How to fix it?

This isn't a bug, its how your server(s) were set up. See this page:

http://dev.mysql.com/doc/refman/5.1/...r-options.html

specifically, the --collation-server and --character-set-server options.

Also, it helps folks to answer you, if you say something about your environment...like what version/distro of Linux, version of MySQL, if it's clustered or not, etc.

Stephan_Craft · 04-06-2009, 07:53 PM

Quote:

Originally Posted by TB0ne

This isn't a bug, its how your server(s) were set up. See this page:

http://dev.mysql.com/doc/refman/5.1/...r-options.html

specifically, the --collation-server and --character-set-server options.

Also, it helps folks to answer you, if you say something about your environment...like what version/distro of Linux, version of MySQL, if it's clustered or not, etc.

I have centos 5.2
5.0.67-community-log MySQL
Apache 2
raid 0

I think this Swedish was always set in mysql. is it a way to change it from the inside? without setting it up in my.cnf?

sleddog · 04-07-2009, 05:37 AM

For some reason MySQL defaults to the Swedish collation if nothing else is set. You can set your preferences in my.cnf, which will affect new databases, and edit existing databases with phpMyAdmin.