Convert your database to UTF-8

Get help with installation and running phpwcms here. Please do not post bug reports or feature requests here.
Post Reply
User avatar
Oliver Georgi
Site Admin
Posts: 9550
Joined: Fri 3. Oct 2003, 22:22
Location: Dessau
Contact:

Convert your database to UTF-8

Post by Oliver Georgi » Mon 2. Mar 2015, 19:27

Hey Guys,

I have developed a database upgrade script which allows to bring older installations of phpwcms to UTF-8. It's in an early stage but it seems to work as expected for ISO-8859-1 (tested a lot with it, other charsets should work too).

It keeps serialised arrays intact and is also able to fix broken serialised arrays (as far I can tell).

It's a one time process taking the old tables and duplicates it with a new table prefix and changes charset to UTF-8 and collation to utf8_unicode_ci — utf8_unicode_ci is more precise compared to utf8_general_ci. Then all rows from the old tables are selected and copied into the new tables. During this step a parser sanitizes all text/binary field values and convert serialised values too.

When finished all you have to do is change phpwcms' config and hope all went well :D

If you like to get your DB converted let me know.

Cheers,
Oliver
Last edited by Oliver Georgi on Mon 2. Mar 2015, 19:33, edited 9 times in total.
Reason: This is important
Oliver Georgi | phpwcms Developer | GitHub | LinkedIn | Kleintierpraxis am Georgengarten

Post Reply