Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
Phoca Tools: Phoca Server Unzip tool, Phoca Changing Collation tool, ...
2 posts • Page 1 of 1
- Phoca Newbie
- Posts: 1
- Joined: 04 Apr 2014, 08:26
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.
- Phoca Hero
- Posts: 44015
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
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.
If you find Phoca extensions useful, please support the project