Database Collation + migration

Joomla version 1.5 is end-of-life and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
HH
Joomla! Guru
Joomla! Guru
Posts: 605
Joined: Fri Dec 29, 2006 11:57 pm
Contact:

Database Collation + migration

Post by HH » Mon Sep 03, 2007 11:29 pm

Hello,
I'm raising this topic for Joomla! developers to discuss + enlightening me/us

Many people (normal/end users) are using the default server installation which depends on creating a database for Joomla! 1.0.1x either manually (using phpMyAdmin or equivillant apps.) or automatically (using Fantastico or equivalent apps.).

Such database is propably and mostly implementing the latin1_swedish_ci collation on many servers not the utf8_unicode_ci or utf8_general_ci

So my 3 simple question are:
1. does J! 1.5 implements the UTF-8?
2. what about the non-latin websites such as Arabic, Chinese, Japanese, Korean, Persian, Hebrew etc?
3. In case 1=Yes, can the com_migrator have an option to upgrade the database collation?

Thanks a lot!
Last edited by HH on Mon Sep 03, 2007 11:34 pm, edited 1 time in total.
Me = Wonder + Ponder
http://www.hichamaged.net/

User avatar
willebil
Joomla! Guru
Joomla! Guru
Posts: 764
Joined: Thu Aug 18, 2005 12:06 pm
Location: Netherlands

Re: Database Collation + migration

Post by willebil » Sun Sep 09, 2007 8:38 pm

1. yes, fully
2. see 1
3. almost certain, but you can always manage that with phpMyAdmin

HH
Joomla! Guru
Joomla! Guru
Posts: 605
Joined: Fri Dec 29, 2006 11:57 pm
Contact:

Re: Database Collation + migration

Post by HH » Mon Sep 17, 2007 11:07 pm

Hi willebil
willebil wrote: 1. yes, fully
2. see 1
Okay for 1 + <--- saw it
willebil wrote: 3. almost certain, but you can always manage that with phpMyAdmin
That's the point
If I'm not wrong, I'm aware that this manual method changes the collation for each table separately, however the final collation still the original one.

For example, I can manually transfer tables from latin1_swedish_ci to utf8_general_ci /utf8_unicode_ci however the final collation still latin1_swedish_ci

That's why I suggested the add-on for the com_migrator script specially that J! 1.5x is applying new architecture or else I appreciate if I've more information or a link to read.

Thanks again for all :)
Last edited by HH on Mon Sep 17, 2007 11:19 pm, edited 1 time in total.
Me = Wonder + Ponder
http://www.hichamaged.net/

HH
Joomla! Guru
Joomla! Guru
Posts: 605
Joined: Fri Dec 29, 2006 11:57 pm
Contact:

Re: Database Collation + migration

Post by HH » Sat Oct 13, 2007 4:52 pm

Hello,
Well, I found the answer for 3.

Manually, using 'Operation' tab for the database itself + tables + raws of each table however it's somehow painful to change the collation of each raw specially for beginners and if you've a bunch of extensions installed.

So my question is still valid, is it possible to have such migration script? ???

Thanks
Last edited by HH on Sat Oct 13, 2007 4:56 pm, edited 1 time in total.
Me = Wonder + Ponder
http://www.hichamaged.net/

User avatar
stampie
Joomla! Apprentice
Joomla! Apprentice
Posts: 44
Joined: Mon May 29, 2006 12:38 pm
Location: Hungary
Contact:

Re: Database Collation + migration

Post by stampie » Mon Oct 15, 2007 6:28 pm

I don't know about a script. But if you are before migration, and you do have phpmyadmin access, I suggest backing up the tables, and set the default collation for the database. (The backup is not specifically needed because altering the default collation does not alter the tables at all, but before an installation it is a good idea.)

By doing this in my localhost installation all tables were created as

HH
Joomla! Guru
Joomla! Guru
Posts: 605
Joined: Fri Dec 29, 2006 11:57 pm
Contact:

Re: Database Collation + migration

Post by HH » Thu Feb 28, 2008 4:25 am

stampie wrote:I don't know about a script. But if you are before migration, and you do have phpmyadmin access, I suggest backing up the tables, and set the default collation for the database. (The backup is not specifically needed because altering the default collation does not alter the tables at all, but before an installation it is a good idea.)

By doing this in my localhost installation all tables were created as
stampie
Yes this is good for installing Joomla! for the 1st time however what I meant is converting the current DB into a UTF-8 complaint one for migrating.

So my two questions:
1- Is it possible to implement a script within com_migrator in future versions of J!?
2- Does anyone know a good script to do this manually?
???

Kindly note that not all users are good in php stuff.

Thanks
Me = Wonder + Ponder
http://www.hichamaged.net/

md54
Joomla! Intern
Joomla! Intern
Posts: 58
Joined: Mon Feb 04, 2008 11:50 pm

Re: Database Collation + migration

Post by md54 » Wed Nov 26, 2008 2:24 am

can any one help us ?

User avatar
brad
Joomla! Master
Joomla! Master
Posts: 13419
Joined: Fri Aug 12, 2005 12:38 am
Location: Sydney - Australia
Contact:

Re: Database Collation + migration

Post by brad » Wed Nov 26, 2008 3:19 am

md54 wrote:can any one help us ?
With?

This is not a thread of yours.. you may want to open your own.
Brad Baker
https://xyzulu.hosting
https://www.joomlatutorials.com <-- Joomla Help & Tutorials

md54
Joomla! Intern
Joomla! Intern
Posts: 58
Joined: Mon Feb 04, 2008 11:50 pm

Re: Database Collation + migration

Post by md54 » Wed Nov 26, 2008 3:34 am

With?
with this : 2- Does anyone know a good script to do this manually?
please .. see above ..
This is not a thread of yours.. you may want to open your own.
i don't think that i can find any reply if i start new topic !!!!

andreikod
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sun Dec 14, 2008 3:00 pm

Re: Database Collation + migration

Post by andreikod » Sun Dec 14, 2008 3:17 pm

stampie wrote:I don't know about a script. But if you are before migration, and you do have phpmyadmin access, I suggest backing up the tables, and set the default collation for the database. (The backup is not specifically needed because altering the default collation does not alter the tables at all, but before an installation it is a good idea.)

By doing this in my localhost installation all tables were created as

Here you have one: http://www.joomla-international.org/for ... ectly.html

It is really very painful tu change collation manually.

Where is the default collation in Joomla instalation configuration file paced?

Best regards.


Locked

Return to “Migrating and Upgrading to Joomla! 1.5”