Results 1 to 1 of 1
May 20, 2013, 08:01 #1
- Join Date
- Mar 2010
- 0 Post(s)
- 0 Thread(s)
Converting Database From LATIN-1 to UTF-8
I have an older database that is still using LATIN-1 as its encoding and I'd like to switch this to UTF-8 for the database, its tables, and their columns.
Would these queries do the trick?
- Do I need to worry about any data/character loss upon conversion of these tables? Or will the conversion be clean?
- What about columns that are currently storing HTML data? This data has been htmlspecialchar()'ed in PHP.
In summary: web pages accepting ISO-8859-1 encoding into a LATIN-1 database switching to UTF-8 all around.
Just want to make sure I don't lose any data before the flip. What do I need to be aware of?
Thanks in advanced.