Collation question w. SQL 4.1

software development

#1

Hey guys,

The upgrade to mySQL 4.1 gives me the choice of collation/character set. Which should I use? Why does it default to latin1_swedish_ci? Shouldn’t I use ascii_general_ci?

I see the ci stands for case insensitive, which I like. Why default to Swedish?

– Scott


#2

I was just wondering this too. I take it nobody ever answered your question?


#3

As confusing as it looks, that latin1_swedish_ci is the correct default character set and should work fine for you unless you need to use asian characters or anything like that.

  • Dallas
  • DreamHost Head Honcho/Founder