Sorry, I haven't touched that issue recently. Where I should turn on
'echo=true', in module or migration script? I saw 'create_engine' has this,
but I didn't directly use 'create_engine'.
SHOW CREATE TABLE gave something back to me:
utf8_general_ci is default collation rule in charset utf8.
mysql> CREATE TABLE t1(col1 CHAR(10) COLLATE utf8_unicode_ci)CHARACTER SET
latin1 COLLATE latin1_bin;
Query OK, 0 rows affected (0.01 sec)
mysql> show create table t1;
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------+
| t1 | CREATE TABLE `t1` (
`col1` char(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin |
mysql> CREATE TABLE t2
-> (
-> col1 CHAR(10) COLLATE utf8_general_ci
-> ) CHARACTER SET latin1 COLLATE latin1_bin;
Query OK, 0 rows affected (0.01 sec)
mysql> show create table t2;
+-------+---------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+-------+---------------------------------------------------------------------------------------------------------------------------------+
| t2 | CREATE TABLE `t2` (
`col1` char(10) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin |
+-------+---------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlalchemy/-/GX-VwGcyfeAJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
