Phoca Changing Collation 
Version
1.0.0 (last update on Dec 20, 2008)
Rating
Compatibility
Votes
12
Favoured
11
License
GPL
Non-Commercial
Type
Views
10657
Date Added
21 June 2008
Instructions:
http://www.phoca.cz/documents/38-tools/154-how-to-change-collation-in-database
bykikas on October 11, 2009
This tool save me a lot of time. I just love all your extensions, you make our life with joomla much easier, thanx for that!
bydangsquall on July 6, 2009
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.
Thanks for this great component it saved me a lot of time and a huge headache.
Very simple and effective!
Very simple and effective!
byDeRos on February 25, 2009
I cant tell you how many times Ive pulled my hair out changing coalation in the past and just recently I needed this and man what a life saver.. Thank you very much for this tool.
bygundestrup on December 29, 2008
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.
byleolam on November 27, 2008
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







