#1640 Explicitly setting collation for a field

Latest_Git_snapshot
fixed
5
2013-06-11
2005-03-29
No

Hi

When I set collation for a field different from table
collation, system does not apply such setting and sets
table's default collation for that field. Using 29 03 2005
CVS snapshot & mysql 4.1.10.

Discussion

  • doguedebordeaux

    doguedebordeaux - 2005-03-29

    Logged In: YES
    user_id=1246524

    When I leave field collation unset, system sets it to default
    table collation nevertheless

     
  • Alexander M. Turek

    Logged In: YES
    user_id=418833

    This might happen if the selected chollation is not compiled
    in. Please try my latest changes.

     
  • doguedebordeaux

    doguedebordeaux - 2005-03-31

    Logged In: YES
    user_id=1246524

    Hi

    I tested latest CVS snapshot, but it works the same as
    before. For example I have table with collation
    utf8_unicode_ci. When I create fields and don't set collation
    for those fields, it autometically assigns table collatiuon for
    those fields. After that I try to change collation for particular
    field to utf8_lithuanian_ci. When I save, the collation remains
    unchanged. And I don't even see a command changing
    collation in upper part of screen. It is simple as "ALTER
    TABLE `hollidays` CHANGE `Holliday_name`
    `Holliday_name` VARCHAR( 50 ) DEFAULT NULL" with no
    set collation.

    Thank you
    dogue de bordeaux

     
  • Ryan Schmidt

    Ryan Schmidt - 2005-05-02

    Logged In: YES
    user_id=838923

    A patch to fix this problem is supplied in bug 1185152.

     
  • Marc Delisle

    Marc Delisle - 2005-05-03
    • status: open --> closed
     
  • Marc Delisle

    Marc Delisle - 2005-05-03

    Logged In: YES
    user_id=210714

    Fix merged, see the other bug entry.

     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed --> fixed