Thanks for reply!
> >> 1. mysql -u root -e "create database t; show create database t; drop
database t"
> >> 2. mysql -u root -e "use_mysql; create database t; show create database
t; drop database t"
> >> 1.| t | CREATE DATABASE `t` /*!40100 DEFAULT CHARACTER SET
cp1251 */
> >> 2.| t | CREATE DATABASE `t` /*!40100 DEFAULT CHARACTER SET
latin1 */
> It's not a bug.
> character_set_database indicates the current database character set.
May be, it wasn't clear.
I say:
when a current database (result of "use ...") in latin1, then "create
database ..." create database in latin1. But default mysql character set is
cp1251! Database, IMHO, must be created in DAFAULT charset. And, IMHO, this
is a bug 8)
Another things:
1. >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'
2. when I create enum fields in cp1251, then "show columns from ..." return
a '????','????',... while all checks, inserts and so work ok. I don't know,
2.1. it's common ciryllic troubles (console in cp866, gui in cp1251)
2.2. it's my local troubles (english win 20000 with ciryllic charset)
2.3 it's mysql troubles (system charset utf8, mysql charset cp1251). NB.
in <table>.frm I see all my enums in selected charset. I think, there is
'phantom' recharacting utf8->cp1251.
And what are Your comments?
WBR!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
