Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Advice Best collation to use

Status
Not open for further replies.

NEE4NEE

Programmer
Nov 23, 2010
14
IN
Hello everyone,

I am creating a desktop application and want to use mysql,
please suggest best collation
mostly no uni-code requirement,
application is accounting type

utf8_bin ?
utf8_general_ci ?
?
?other
 
Depends on how you intend or need to search and sort the data.

_bin collation is a search and sort on the binary value of the character

general_ci uses general language rules and case insensitive comparisons

general_cs uses general language rules and case sensitive comparisons

as an example

Ä = A
Ö = O
Ü = U
Will evaluate as true with a "general_cs" collation but not with a _bin collation and with a general_ci collation letter case is ignored.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

Never mind this jesus character, stars had to die for me to live.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top