Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

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
0
HelpNearMe
Asked:
HelpNearMe
  • 2
  • 2
1 Solution
 
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
 
Aaron TomoskyTechnology ConsultantCommented:
I just use the default top level Latin 1.
0
 
HelpNearMeAuthor Commented:
ok thanks
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now