1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

phpMyAdmin default character set problem

Discussion in 'Plesk for Windows - 8.x and Older' started by pun119, Jan 7, 2006.

  1. pun119

    pun119 Guest

    In phpMyAdmin home I can't change collation or other character set todefault.

    This collation character set couse problem with website with forign languase (ex:Thai) that fetch data from Mysql to show ex: web board and forum because it default character set is set to latin.

    Any one have way to fix this problem.

    My solution so far is to put a code in side web page which take time if I have to do this with all of my clients.

    Any solution will be very thankful.

  2. matija

    matija Guest

    I had problems with Collation after importing database exported from older version of phpMyAdmin... Is it the same case with you?
  3. pun119

    pun119 Guest

    I think it is the same problem .
    I also export data from other server phpmyadmin with older ver. than my.
  4. matija

    matija Guest

    Then, you have the same problem as I did. User needed to migrate his MySQL database to our server which had newer version of phpMyAdmin installed.
    After import to our server, Collation fields were all set to latin_swedish instead of cp1250_xxx and that was, as far as I remember, due to older version of phpMyAdmin not exporting CHARSET values along with data.
    I don't remember whether I added this values manually to all tables (thankfully it was only 1 database) or I executed SQL query's on each table within phpMyAdmin...

    ALTER TABLE your_table_name CONVERT TO CHARACTER SET your_new_encoding;
  5. pun119

    pun119 Guest

    Thank you I give it a try but my data contain 70 table This might take time.:D