1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    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

    0
     
    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.

    :cool:
     
  2. matija

    matija Guest

    0
     
    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

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

    matija Guest

    0
     
    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...

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

    pun119 Guest

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