SQL
mysql
HI, All!
I have a question.
I migrate from 4.0.14 to 4.1.0 but:
the 4.0.14 show me:
mysql> desc statname;
+----------+-----------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------------+------+-----+---------------------+-------+
| statname | char(16) binary | | PRI | unknown | |
| passwd | char(64) binary | | | * | |
| env | char(10) | | | | |
| area | int(11) | | | 0 | |
| manager | char(16) binary | | | | |
| d_create | datetime | | | 0000-00-00 00:00:00 | |
| d_change | datetime | | | 0000-00-00 00:00:00 | |
| wizard | int(11) | | | 0 | |
+----------+-----------------+------+-----+---------------------+-------+
And 4.1.0 show me on the sane table:
mysql> mysql> desc statname;
+----------+------------------------------+------------------+------+-----+---------------------+-------+
| Field | Type | Collation | Null | Key
| Default | Extra |
+----------+------------------------------+------------------+------+-----+---------------------+-------+
| statname | char(16) character set koi8r | koi8r_general_ci | | PRI
| unknown | |
| passwd | char(64) character set koi8r | koi8r_general_ci | |
| * | |
| env | char(10) character set koi8r | koi8r_general_ci | |
| | |
| area | int(11) | binary | |
| 0 | |
| manager | char(16) character set koi8r | koi8r_general_ci | |
| | |
| d_create | datetime | koi8r_general_ci | |
| 0000-00-00 00:00:00 | |
| d_change | datetime | koi8r_general_ci | |
| 0000-00-00 00:00:00 | |
| wizard | int(11) | binary | |
| 0 | |
+----------+------------------------------+------------------+------+-----+---------------------+-------+
But where is my binary flags?
Select use fields as binary.
But I don't want binary on each field.
I need old types on fields.
How can I resolv this?
Best regards.
_______________________________________
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
тел. +380 562 34-00-44
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
