SQL mysql Hi, All. Other question is: Can I create case sensitive field with right ordering of national characters.
> > 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] > > 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]
