/ Register

Want to subscribe to topics you're interested in?
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 rdan, Mar 18, 2016.

Previous Thread Next Thread
Loading...
  1. Mar 18, 2016 #1
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:46 AM
    Mainline
    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. Mar 18, 2016 #2
    pamamolf

    pamamolf Premium Member Premium Member

    4,086
    428
    83
    May 31, 2014
    Ratings:
    +834
    Local Time:
    8:46 PM
    Nginx-1.25.x
    MariaDB 10.3.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. Mar 18, 2016 #3
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:46 AM
    Mainline
    10.2
    Sadly for me that didn't work.
    It messed up Vietnamese Characters.
     
  4. Mar 18, 2016 #4
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    7:46 PM
    Nginx 1.17.9
    MariaDB 10.3.22
    Try to set both character set (collation) to same before restoring. On database (new one) and on server (sql)
     
Previous Thread Next Thread
Loading...

.