What is a sort rule (collation)
About SQL Server collation, it is estimated that everyone is not unfamiliar, when creating a database we often have to choose a collation (conllation), generally we will notice that there are many kinds of rules for each language, such as standard Continental Simplified Chinese chinese_ There are dozens of of the collation rules for PRC.
What's the effect of these collations? Let's take a look at MS official explanations:
The collation specifies the
In the process of using the database, there are always some special needs. Sometimes it is necessary to store Chinese characters, to be case-sensitive or to be sorted in the order of the English. This involves the choice of database arrangement rules. We can generally choose the database name-right-click (properties)--"function (optiotion)--" Sorting mode (Collation) selection. * Because there is no Chinese version of the database, Chinese translation may be incorrect. So what is the differenc
explanation, you can set the following parameters:
Casesensitivity
The
CI specifies case-insensitive, and the
CS -specified sensitivity is casing-sensitive.
Accentsensitivity
AI Specifies accent-insensitive,
as specifies accent sensitivity.
Kanatypesensitive
omitted Specifies that kana types are not distinguished, and
KS specifies
LOWER-GREEK:CSS2
Hebrew:css2 the traditional Hebrew numbers
Hiragana:css2 Japanese plain Kana character
Hiragana-iroha:css2 Japanese Hiragana Order
Katakana:css2 Japanese piece Kana character
Katakana-iroha:css2 Japanese Katakana Number
Lower-latin:css2 Lowercase Latin alphabet
Upper-latin:css2 Capital Letter Latin
*list-style-image:url (images/disc.gif); Using image disc.gif instead of list items
"think う". So this has been said before.
Here we will learn a new verb's flexible form: the verb's will form. This is also called a form in the book, but because of fear and the formation of the ii+ of negation, so we call this "よ" う"is called the shape of the will.
The change rule of the will shape is:
Five verbs: Turn the suffix kana into a pseudonym on "お", plus "う".
A verb: Directly remove the kana on
South Korea symbol area. Host Kangxi Dictionary Radicals, Chinese and Japanese auxiliary radicals, phonetic symbols, Japanese kana, Korean notes, Chinese and Japanese symbols, punctuation, circled or with rune numbers, month, and Japan's kana combination, units, the year, month, date, time and so on.3400~4DFFH: China, Japan and South Korea agree to the ideographic expansion of a district, a total of 6,582
, computational symbols, Greek letters, and special Latin symbols.
GB2312 Character Set
1. The origin of the name
GB2312 also known as the gb2312-80 character set, the full name of "Information exchange with Chinese character encoding character set," The basic set, issued by the original China National Standards Bureau, May 1, 1981 implementation.
2. Characteristics
GB2312 is the Chinese national standard Simplified Chinese character set. It has been included in the Chinese characters have
Hiragana:css2 Japanese plain Kana character
Hiragana-iroha:css2 Japanese Hiragana Order
Katakana:css2 Japanese piece Kana character
Katakana-iroha:css2 Japanese Katakana Number
Lower-latin:css2 Lowercase Latin alphabet
Upper-latin:css2 Capital Letter Latin
*list-style-image:url (images/disc.gif); Use image disc.gif instead of list item display
*list-style-position:outside | Inside
Outside: List item tag is
css| Project
This tutorial mainly explains the definition of the style of common tags
Li {list-style-image:url (images/disc.gif);}
This style definition for Li is to use a picture for a list item instead of a small dot that is displayed. Of course, you can also display other effects, see the following definition in detail:
CSS definition of the effect of a list item
*list-style-type:circle (You can change the style you want); List Item Style
Disc:css1 Solid Circle
Circle:css1 Hollow Circle
Sq
:
Chinese_prc_cs_ai_ws
First half: Refers to the Unicode character set, the collation of the CHINESE_PRC_ pointer to the Chinese simplified characters Unicode.
The latter part of the collation is the suffix meaning:
_bin binary Sorting
_ci (CS) is case-sensitive, CI does not differentiate, CS differentiates
_ai (AS) is accent-sensitive, AI does not differentiate, as differentiates
Whether _ki (KS) differentiates kana types, KI does not differentiate,
, computational symbols, Greek letters, and special Latin symbols.
GB2312 Character Set
1. The origin of the name
GB2312 also known as the gb2312-80 character set, the full name of "Information exchange with Chinese character encoding character set," The basic set, issued by the original China National Standards Bureau, May 1, 1981 implementation.
2. Features
GB2312 is the Chinese national standard Simplified Chinese character set. It has been included in the Chinese characters have covered
Miniature supercapacitors made of DVD burners
American researchers recently unveiled a new battery they have developed that can charge phones and even cars in seconds.
This device, called a micro-graphene supercapacitor, charges or discharges 100 times times as fast as 1000 times times faster than conventional batteries. The use of a single atom of carbon-based batteries is easy to produce, but also easy to combine with electronic products, and may even lead to the emergence of smaller mobile ph
option if you want the comparison to treat accented and non-accented letters as unequal. If you select this option, the comparison also treats letters with different accents as unequal._ki (KS) Whether the kana type is differentiated, KI does not differentiate, KS differentiates kana: Select this option if you want the comparison to treat katakana and hiragana Japanese syllables as unequal._WI (WS) Whether
path] setWhere the collation name is composed of two parts, the first half refers to the character set supported by this collation.Such as:Chinese_prc_cs_ai_wsFirst half: Refers to the Unicode character set, chinese_prc_ the pointer to the mainland simplified Unicode collation. The second half of the collation is the suffix meaning:_bin binary Ordering_ci (CS) is case sensitive, CI is not differentiated, CS is case sensitive: Select this option if you want comparisons to treat uppercase and lo
,
_ KI (KS) indicates whether Kana is distinguished. KI is not distinguished, and KS is distinguished.
_ Whether WI (WS) is differentiated by width WI and WS
Case Sensitive: select this option if you want to make the comparison between uppercase and lowercase letters different.
Accent differentiation: select this option if you want to treat the comparison as different from the accent and non-accent letters. If this option is selected, the comparis
the database sorting rule is Chinese_PRC. So I created a new database, set the sorting rule to chinses_ci_ai, and then import the data. This solves the problem.
PS: What is a sorting rule? "In Microsoft SQL Server 2000,
The physical storage of strings is controlled by sorting rules. Sorting rules specify the bit mode and storage of each character
Rules Used for saving and comparing characters. "
Run the following statement in the query analyzer to obtain all the sorting rules supported by SQL S
lowercase Numeric strings into uppercase Numeric strings in simplified Chinese, traditional Chinese, Japanese, and Korean.
Japanese Kana Conversion Library-supports converting Japanese Kana to another Japanese character.
Japanese Text Alignment Library-supports a Japanese-specific Alignment format.
The Japanese Yomi Auto-Completion Library-Class Library supports the input of the daily input method and a
.
The name of a sorting rule consists of two parts. The first half is the character set supported by this sorting rule.
For example: chinese_prc_cs_ai_ws
First half: the Unicode character set. The chinese_prc _ pointer sorts Unicode in simplified Chinese characters.
The second half of the sorting rule is the suffix meaning:
_ Bin binary sorting
_ Ci (CS) is case sensitive, CI is case insensitive, and CS is case sensitive
_ Whether AI (AS) distinguishes stress, AI does not distinguish,
_ KI (KS)
The input name corresponds to the keyboard name.
The pronunciation of Japanese Kana is represented by a Roman letter. When you use a computer such as Word or Excel to process Japanese data, you enter Japanese in the Japanese input mode. Japanese Kana can be input using their own Roman pronunciation or a unique combination on the keyboard. I have seen such a learning post in other forums. I have posted a co
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.