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 Chris Miller 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
- Thread starter NEE4NEE
- Start date
ChrisHirst
IS-IT--Management
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
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.
_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
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