Hi!
How I can set server variable "character_set_system" to cp1251 ?
I can use xxx'char' construction - but I need a downward compatibility.
I can select USER() and parse result on clientside - but I wan't rewrite
existing client apps.
> mysql -u root -e "select substring_index(USER(),'@',1)"
ERROR 1266 at line 1: Illegal mix of collations (utf8_general_ci,IMPLICIT)
and (
cp1251_general_ci,COERCIBLE) for operation 'substr_index'
> mysql -u root -e "show variables like '%character_set%'"
+--------------------------+--------------------------+
| Variable_name | Value |
+--------------------------+--------------------------+
| character_set_server | cp1251 |
| character_set_system | utf8 |
| character_set_database | cp1251 |
| character_set_client | cp1251 |
| character_set_connection | cp1251 |
| character_set_results | cp1251 |
+--------------------------+--------------------------+
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
