I wouldn't call it normal. I am not sure there is a normal collation. If you state nothing else MySQL will choose utf8_general_ci so that would be the default.
Binary collation is the collation for non-lingual text. Every character counts and order clauses cause them to be ordered by their code-number, not any alphabet. Every other collation attempts to follow the rules of particular languages. They each have a cs and ci version for case (in) sensitivity. The general and unicode collations are quite similar in behavior (can't remember the differences) and roughly equate to the rules of the English language. If you only store basic English characters you are luck and can stop worrying now. But storing Swedish names in such a field will make poopie out of string comparisons and ordering of results. Ä be an A with some insignificant dots, even though it is a separate character in the Swedish language. The same goes for Spanish and any other language with anything but the 26 characters a-z. So, to cope with Swedish there is a utf8_swedish_ci (or cs) which recognizes Ä as it's own character but é as just an e and so on. I had a word of trouble with collations on a project last year. I was taken by surprise when MySQL decides to see A and Ä as the same character in where clauses... I thought collation was for ordering only, but it affects where statements, indexes and other things as- well. I strongly recommend reading the confusing and boring pages in the MySQL manual on the subject if you store and search for data in any language other than English. /Martin On Feb 4, 1:37 am, Webweave <webwe...@gmail.com> wrote: > The "ci" flavors are for case-insensitive versions, so if you want > "John" to be equal to "john" with no case conversion, you use one of > them. > > The utf8_bin is the "normal" collation. > > On Feb 3, 10:28 am, BrendonKoz <brendon...@hotmail.com> wrote: > > > While on this subject, which MySQL table encoding is the "normal", > > default utf-8 encoding? utf8_bin, or utf8_general_ci, or > > utf8_unicode_ci? > > > On Feb 3, 8:48 am, Marcelo Andrade <mfandr...@gmail.com> wrote: > > > > On Tue, Feb 3, 2009 at 8:55 AM, mohammad al-ani > > > > <alani.moham...@gmail.com> wrote: > > > > Dr. Loboto all of my pages encoded with utf-8 and the problem is not in > > > > my > > > > page the problem is with the firefox and everything go perfect with IE > > > > It works on IE because the CP-1252 encoding is a Windows-specific encoding > > > that works primarily on the Microsoft products. Unless you intend to > > > make your > > > pages working only on IE, don't use it. > > > > To solve your problem, open all of your files in a smart text editor and > > > resave > > > all of them with the UTF-8 (without BOM) encoding. Check your editor > > > about > > > doing this. > > > > Best regards. > > > > -- > > > MARCELO DE F. ANDRADE (aka "eleKtron") > > > Belem, PA, Amazonia, Brazil > > > Linux User #221105 > > > > [...@pará ~]# linkshttp://pa.slackwarebrasil.org/ > > > > For Libby's backstory be told on > > > Losthttp://www.petitiononline.com/libby423/petition.html --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
