Why use latin1 general bin

Improve this answer. Back to the question For English, there is no difference. If this is all you will ever have, then pick either one. And the ordering of accented letters is different. For characters from the rest of the world -- You won't be able to store them in latin1 , but you can store most of them in utf8. The MySQL world is moving toward utf8mb4. Rick James Rick James k 10 10 gold badges silver badges bronze badges.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Create a free Team What is Teams? Learn more. Asked 6 years, 3 months ago. Active 6 years, 1 month ago. Viewed 34k times. Improve this question. Community Bot 1. Rakesh Rakesh 1 1 gold badge 1 1 silver badge 6 6 bronze badges. Add a comment. Active Oldest Votes.

Improve this answer. Col1 FROM dbo. Example 5 when a binary comparison is not case-sensitive : True case-sensitive comparisons allow for combining characters that, in combination with another character, form yet another character that already exists as another Unicode code point. Solomon Rutzky Solomon Rutzky Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Explaining the semiconductor shortage, and how it might end.

Does ES6 make JavaScript frameworks obsolete? Featured on Meta. Now live: A fully responsive profile. Linked 2. Related 3. CollationDesignator Specifies the base collation rules used by the Windows collation. The base collation rules cover the following:. KanatypeSensitive Omitting this option specifies kanatype-insensitive, KS specifies kanatype-sensitive.

WidthSensitivity Omitting this option specifies width-insensitive, WS specifies width-sensitive. Omitting this option specifies variation selector-insensitive, VSS specifies variation selector-sensitive. Specifies UTF-8 encoding to be used for eligible data types. For more information, see Collation and Unicode Support. BIN2 Specifies the binary sort order that uses code-point comparison semantics. For example, compare the output of the LOWER function when it is given the same character, but in different versions of the same collation:.

The first statement shows both uppercase and lowercase forms of this character in the older collation collation does not affect the availability of characters when working with Unicode data.