Charset conversion

1

I have a website to develop for a client and his MySQL database looks like this:

  

Database Properties: Character set: latin1 - cp1252 West European; Collation: latin1_general_ci

     

The tables are all like this: Character set: utf8 - UTF-8 Unicode; Collation: utf8_general_ci

The new bank will be:

  

Database Properties: Character set: Character set: utf8 - UTF-8 Unicode; Collation: utf8_general_ci

     

The tables are all like this: Character set: utf8 - UTF-8 Unicode; Collation: utf8_general_ci

Does this difference between the properties of the database force me to do some conversion of the data so as not to lose accent and special characters?

    
asked by anonymous 22.04.2015 / 20:33

1 answer

0

You will not have problems, Database Properties defines the "default" that will be used in the "table creation" when this is not set a charset it picks up the Database default.

As you already have the tables all in utf-8, and will send to a Database where everything is utf-8 you do not have to do anything other than a normal backup / restore.

    
22.04.2015 / 21:20