What is the difference between utf8_unicode_ci and utf8_general_ci

General questions regarding the use of languages and encoding issues in Joomla! 1.0.x. Multi-lingual site solutions can be discussed in the child board. Translation discussions are now separate and can be found in the Working Groups Area.
Locked
User avatar
aravot
Joomla! Ace
Joomla! Ace
Posts: 1015
Joined: Thu Aug 18, 2005 1:16 am
Location: Glendale, CA, USA
Contact:

What is the difference between utf8_unicode_ci and utf8_general_ci

Post by aravot » Sat Dec 30, 2006 4:00 am

What is the difference between utf8_unicode_ci and utf8_general_ci? What are the effects of choosing one over the other? Which should we use for Joomla! 1.0.x and Joomla! 1.5?

User avatar
infograf768
Joomla! Master
Joomla! Master
Posts: 19056
Joined: Fri Aug 12, 2005 3:47 pm
Location: **Translation Matters**

Re: What is the difference between utf8_unicode_ci and utf8_general_ci

Post by infograf768 » Sat Dec 30, 2006 11:06 am

David, when he tested to make Joomla! 1.5 compatible, went for general per default.
This is also what I do for a 1.0.x site.

I don't really know the difference though. :'(
Jean-Marie Simonet / infograf · http://www.info-graf.fr
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group

User avatar
ruigato
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Sat Aug 20, 2005 4:12 pm
Location: Arouca - Portugal
Contact:

Re: What is the difference between utf8_unicode_ci and utf8_gene

Post by ruigato » Sun Oct 12, 2008 3:58 pm

due to some permission limitations i just migrated a site from an installation in utf8_general_ci to a database in utf8_unicode_ci, at the first glance all seem nornal, do you think i will have problems in the future?

Thanks

User avatar
infograf768
Joomla! Master
Joomla! Master
Posts: 19056
Joined: Fri Aug 12, 2005 3:47 pm
Location: **Translation Matters**

Re: What is the difference between utf8_unicode_ci and utf8_gene

Post by infograf768 » Sun Oct 12, 2008 4:30 pm

Jean-Marie Simonet / infograf · http://www.info-graf.fr
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group


Locked

Return to “Language - 1.0.x”