Collation convert existing data

Phoca Tools: Phoca Server Unzip tool, Phoca Changing Collation tool, ...
siteox
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 04 Apr 2014, 08:26

Collation convert existing data

Post by siteox » 04 Apr 2014, 08:33

I have a database that was created using the iso-8859-1 charset, several years ago. It contains years worth of data. I now need to convert it to utf-8. Does the Phoca Changing Collation Tool convert the existing data, within the database, or is it just changing the default collation on the database and tables? Does it do any type of conversion to make sure the existing data is in utf-8 format? I've read where people do this by dumping the database, running iconv on the dump file, then importing the data back in using the correct charset. I'm not sure if the iconv step is required to get the data in the correct format.

Thanks,
Sean

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42872
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Collation convert existing data

Post by Jan » 08 Apr 2014, 22:34

Hi, it just change the collation (such can be used for converting the data) You can test it but of course, it is better to export/import the data to some test database server and try to change the collation in test server. It is not recommended to do it on live server.

Jan
If you find Phoca extensions useful, please support the project

Post Reply