Seting up mysql default charset

[mydomain]

Hi, we need to set up cp1251 as default charset for one user's mySQL database, does anyone know if that is possible and how we can do that?

TIA

[mickalo]

Originally posted by mydomain
Hi, we need to set up cp1251 as default charset for one user's mySQL database, does anyone know if that is possible and how we can do that?

TIA

You'll need to change the default character set which is normally latin1 by setting the variable:
character_set in your my.cnf main option file to the value you need. I believe this would be under the mysqld group settings, but you may want to double check that. Check out MySQL Docs for more info

Mickalo

[mydomain]

That will be a global change? How will that impace mysql functions for all other users?

[mickalo]

Originally posted by mydomain
That will be a global change? How will that impace mysql functions for all other users?

Yes, that would be a global change. I don't think it can be changed on an individual user basices prior to Version 4.1, but you maybe able to utilize the SET option during the client's active session, but you'd find a bit more indepth info on that from the MySQL docs. Or compile a separate MySQL server/client to use this other character set for this user if it's real critical. Setting up multiple MySQL isn't really difficult to do, even with Cpanels... done it a few times before.

Mickalo

[Devil Inside]

How would I make the change to latin5 for one user's account?

[haze]

You will need to drop the appropriate configuration into a my.cnf file within the users account. For more information, see the mysql docs as this step varries depending on which version of mySQL you run:

http://dev.mysql.com/doc/mysql/en/se...variables.html

[Devil Inside]

Great - thanks haze

[myweb]

You will need to drop the appropriate configuration into a my.cnf file within the users account. For more information, see the mysql docs as this step varries depending on which version of mySQL you run:

http://dev.mysql.com/doc/mysql/en/se...variables.html

I have created .my.cnf file and put it under the home directory of a specific user, but the character set value still remains as the global value (which is ujis).

[mysql]
default-character-set=sjis
[mysqld]
default-character-set=sjis
[client]
default-character-set=sjis

Am I doiing something wrong, or is it that Cpanel does not allow the use of a user defined .my.cnf configuration file?