mySQL/phpAdmin collation field


#1

I’ll try my questions in this beginners forum.
RTFMs appreciated.

Just created a mySQL table. By default, the collation field is set to latin1_swedish_ci.

I am in the US, the field contents will be “normal ascii”, case insensitive.

What is my “best” value for setting the collation field? ascii_general_ci? utf_unicode_ci?

Where can I find out more about this field/setting, and what it is for?

TIA,
Rudy


#2

First, I’m not a expert. I don’t feel confident to give suggestions. :wink:

Usually I leave it as default. But when I need to handle other languages like chinese, japanese, I set it to UTF.

Save $97 with promo code: [color=#CC0000]97YES Sign Up NOW[/color]


#3

that is the default, no need to change it. and the obligatory manual:
http://dev.mysql.com/doc/refman/5.1/en/charset-we-sets.html


#4

shall we say that is default for western characters?

and we should change it for Asian Characters?

Actually I used default latin1 for Asian characters before. Although you see funny characters in database, it does not affect the display in html page.

Save $97 with promo code: [color=#CC0000]97YES Sign Up NOW[/color]


#5

Thanks for the RTFM.

I have learned:

  • The default is Swedish because the company is in Sweden (doh)
  • The default will generally not be a problem if there are no special characters
  • If there are no special characters, the simplest collation is ascii_general_ci

Again, thanks for the replies.

Rudy