Phoca Changing Collation
Version
1.0.0 (last update on Dec 20, 2008)
Rating
Compatibility
Votes
Favoured
14
License
GPLv2 or later
Non-Commercial
Type
Views
34036
Date Added
21 June 2008
Instructions:
http://www.phoca.cz/documents/38-tools/154-how-to-change-collation-in-database
Generally it take me 4 hours to change all this settings in phpmyadmin. And I become crazy after 2 hours of changing these collations...
I need these changes to be done because of the Croatian language of my sites. You cannot write these letters: ššđćžč
With this tool you will change them in ONE minute max....
I think that it is good and great... thank you guys or ladies...
A super good tool for non english site....
Best wishes
I need these changes to be done because of the Croatian language of my sites. You cannot write these letters: ššđćžč
With this tool you will change them in ONE minute max....
I think that it is good and great... thank you guys or ladies...
A super good tool for non english site....
Best wishes
I've just used this to change some collation inconsistencies in my database. It was easy and quick. Thanks for such a neat tool!
great tool! i needed a quick way to change my database to utf8_general_ci, and this tool does it in a heartbeat!
totally recommended for any of you who's thinking of changing your site's language or database collation.
totally recommended for any of you who's thinking of changing your site's language or database collation.
Problem:
Multiable db (Joomla, Mediawiki) that uses latin1 ISO-8859-1
Solution:
1) Use iconv under linux, after an export of the db, and the upload to a new db.
And change the the collation under phpmyadmin
(been trying to get the time, for a long time...never happend)
2) Make a backup of your db, upload it to a new database, and apply this tool, and presto 1-2-3 all done.
I have nothing but positive words for this tool, easy, quick and it didn't break anyting :-)
It fixed my Joomla db and also mediawiki dbs.
Multiable db (Joomla, Mediawiki) that uses latin1 ISO-8859-1
Solution:
1) Use iconv under linux, after an export of the db, and the upload to a new db.
And change the the collation under phpmyadmin
(been trying to get the time, for a long time...never happend)
2) Make a backup of your db, upload it to a new database, and apply this tool, and presto 1-2-3 all done.
I have nothing but positive words for this tool, easy, quick and it didn't break anyting :-)
It fixed my Joomla db and also mediawiki dbs.
This is a wonderful little script which works fabulous simple and changes the collation of your entire database in less than a minute.
Highly advised for people who need to change collation.....No need for mysql knowledge. you only need your
* database name
* database username
* database-password
* new collation required
enter in a little form in your browser (upload a folder to joomla root of 16K and you are done)
note change the name of the folder into something easier such as "changing_collation"
the only thing you do than is run the script in your browser: http://www.yoursitename/changing_collation/index.php
Very good!
leolam
joomagroup
Highly advised for people who need to change collation.....No need for mysql knowledge. you only need your
* database name
* database username
* database-password
* new collation required
enter in a little form in your browser (upload a folder to joomla root of 16K and you are done)
note change the name of the folder into something easier such as "changing_collation"
the only thing you do than is run the script in your browser: http://www.yoursitename/changing_collation/index.php
Very good!
leolam
joomagroup