Want more timely Centmin Mod News Updates?
Become a Member

MariaDB How to properly export from Mysql 5.5 and preserve Vietnamese characters?

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by RoldanLT, Mar 18, 2016.

  1. RoldanLT

    RoldanLT Well-Known Member

    3,901
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    5:47 AM
    1.11
    10.2
    I am migrating some Data from a server with Mysql 5.5.
    Database has default latin1 collation.

    When I import it to MariaDB 10.1 server, Vietnamese characters messed up even if I use the same database collation.

    I even tried:

    mysqldump -uroot -pXXXXXXXX --default-character-set=latin1 DB_name > DB_name.sql
    mysql -uroot -pXXXXXXXX --default-character-set=latin1 DB_name < DB_name.sql


    Still messing up the characters.
    Please advice :/
     
  2. pamamolf

    pamamolf Well-Known Member

    2,722
    242
    63
    May 31, 2014
    Ratings:
    +433
    Local Time:
    12:47 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    A simple dump without any parameters and setting the exact same database character set on the new server and then a simple import is always ok for me and i mess always with unicode characters without any issues.....
     
  3. RoldanLT

    RoldanLT Well-Known Member

    3,901
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    5:47 AM
    1.11
    10.2
    Sadly for me that didn't work.
    It messed up Vietnamese Characters.
     
  4. Sunka

    Sunka Active Member

    917
    240
    43
    Oct 31, 2015
    Rijeka, Croatia
    Ratings:
    +388
    Local Time:
    11:47 PM
    Nginx 1.13.3
    MariaDB 10.1.24
    Try to set both character set (collation) to same before restoring. On database (new one) and on server (sql)