Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#1706 (in 2.6.3) Cannot change table's collation

2.6.3-rc1
fixed
Marc Delisle
1
2013-06-11
2005-06-22
Drew
No

Using the following:
- PHP 5.0.4
- MySQL 5.0.4b
- Apache 2.0.52
- phpMyAdmin 2.6.3 rc1

1) I click on Operations for any given table.

2) I select 'latin1_bin' from the Collation dropdown
menu, changing it from the current 'latin1_swedish_ci'.

3) I click submit to save the change, but the SQL that
is generated is (regardless of the collation I choose):

ALTER TABLE `Listing` DEFAULT CHARACTER SET latin1
COLLATE latin1_swedish_ci

Discussion

  • Garvin Hicking
    Garvin Hicking
    2005-06-22

    Logged In: YES
    user_id=473563

    Which browser are you using? Can you reproduce this problem
    with a different browser like Opera or IE or Mozilla?

    To me it seems that your server is not getting the values
    you submitted. Some Mozilla Extensions are known to cause
    such trouble.

     
  • Drew
    Drew
    2005-06-22

    Logged In: YES
    user_id=1143809

    This occurs under both Firefox 1.0.4 and IE 6.0 SP2 on
    Windows XP Pro.

    If I stick print_r($_POST); at the top of
    tbl_properties_operations.php and then submit the change, I
    get the following:

    Array ( [lang] => en-utf-8 [server] => 1
    [collation_connection] => utf8_general_ci [db] => realestate
    [table] => test [tbl_collation] => latin1_bin
    [submitcollation] => Go )

    but the SQL that gets generated is the same as in my first
    comment.

     
    • assigned_to: rabus --> nobody
    • labels: 667855 --> Navigation/Usability
     
  • Marc Delisle
    Marc Delisle
    2005-06-28

    • assigned_to: nobody --> lem9
     
  • Marc Delisle
    Marc Delisle
    2005-06-28

    Logged In: YES
    user_id=210714

    fixed in cvs

     
  • Marc Delisle
    Marc Delisle
    2005-06-28

    • priority: 5 --> 1
    • summary: Cannot change table's collation --> (in 2.6.3) Cannot change table's collation
    • status: open --> open-fixed
     
  • Marc Delisle
    Marc Delisle
    2005-07-03

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

    • Status: closed-fixed --> fixed