MySQL Collation setting

Hi Experts,

I am building a db in MySQL 5 that will contain city,state, region, and country names.  These names may include some language specific characters (Chinese, Russian, French, Spanish).  What collation setting would best accomodate most or all possibilities.

Thanks,

HN
HelpNearMeAsked:
Who is Participating?
 
Aaron TomoskyConnect With a Mentor Technology ConsultantCommented:
I just use the default top level Latin 1.
0
 
Aaron TomoskyTechnology ConsultantCommented:
Chinese is the tricky one. Latin 1 can handle all the rest. You may need to base64encode and decode for that to work.
0
 
HelpNearMeAuthor Commented:
Ok, forget Chinese... I probably won't use it.  So from the options shown in the attached image, which would you choose for a primarily English DB that may include some country names that could have some wierd characters or accents.

THanks,

HNM
sample8-03.jpg
0
 
HelpNearMeAuthor Commented:
ok thanks
0
All Courses

From novice to tech pro — start learning today.