2.325.4 DataSet.Collation

The DataSet.Collation element specifies the locale to use for the collation sequence for sorting data. This element is optional. This element MUST NOT be specified if DataSet.CollationCulture is present.

If this element is not present or has an unsupported or invalid value and DataSet.CollationCulture is not present, the collation setting is autoderived by querying the data provider. If the data provider does not support autoderivation or returns an unsupported or invalid value, the collation that corresponds to the value of the Report.Language element MUST be used.

The supported locales for this element are as follows:

Albanian: The Albanian locale.

Albanian_100: The Albanian locale.<64>

Amharic_100: The Amharic locale.<65>

Arabic: The Arabic locale.

Arabic_100: The Arabic locale.<66>

Armenian_100: The Armenian locale.<67>

Assamese_100: The Assamese locale.<68>

Azeri_Cyrillic_90: The Azeri Cyrillic locale.<69>

Azeri_Cyrillic_100: The Azeri Cyrillic locale.<70>

Azeri_Latin_90: The Azeri Latin locale.<71>

Azeri_Latin_100: The Azeri Latin locale.<72>

Bashkir_100: The Bashkir locale.<73>

Bengali_100: The Bengali locale.<74>

Bosnian_Cyrillic_100: The Bosnian Cyrillic locale.<75>

Bosnian_Latin_100: The Bosnian Latin locale.<76>

Breton_100: The Breton locale.<77>

Chinese_Hong_Kong_Stroke_90: The Chinese Hong Kong Stroke locale.<78>

Chinese_Hong_Kong_Stroke_100: The Chinese Hong Kong Stroke locale.<79>

Chinese_Macao_100: The Chinese Macao locale.<80>

Chinese_Macao_Stroke_100: The Chinese Macao Stroke locale.<81>

Chinese_PRC: The Chinese PRC locale.

Chinese_PRC_100: The Chinese PRC locale.<82>

Chinese_PRC_Stroke: The Chinese PRC Stroke locale.

Chinese_PRC_Stroke_100: The Chinese PRC Stroke locale.<83>

Chinese_Simplified_Pinyin_100: The Chinese Simplified Pinyin locale.<84>

Chinese_Simplified_Stroke_Order_100: The Chinese Simplified Stroke locale.<85>

Chinese_Taiwan_Bopomofo: The Chinese Taiwan Bopomofo locale.

Chinese_Taiwan_Bopomofo_100: The Chinese Taiwan Bopomofo locale.<86>

Chinese_Taiwan_Stroke: The Chinese Taiwan Stroke locale.

Chinese_Taiwan_Stroke_100: The Chinese Taiwan Stroke locale.<87>

Chinese_Traditional_Bopomofo_100: The Chinese Traditional Bopomofo locale.<88>

Chinese_Traditional_Pinyin_100: The Chinese Traditional Pinyin locale.<89>

Chinese_Traditional_Stroke_Count_100: The Chinese Traditional Stroke Count locale.<90>

Chinese_Traditional_Stroke_Order_100: The Chinese Traditional Stroke Order locale.<91>

Corsican_100: The Corsican locale.<92>

Croatian: The Croatian locale.

Croatian_100: The Croatian locale.<93>

Cyrillic_General: The Cyrillic General locale.

Cyrillic_General_100: The Cyrillic General.<94>

Czech: The Czech locale.

Czech_100: The Czech locale.<95>

Danish_Greenlandic_100: The Danish Greenlandic locale.<96>

Danish_Norwegian: The Danish Norwegian locale.

Dari_100: The Dari locale.<97>

Divehi_90: The Divehi locale.<98>

Divehi_100: The Divehi locale.<99>

Estonian: The Estonian locale.

Estonian_100: The Estonian locale.<100>

Finnish_Swedish: The Finnish Swedish locale.

Finnish_Swedish_100: The Finnish Swedish locale.<101>

French: The French locale.

French_100: The French locale.<102>

Frisian_100: The Frisian locale.<103>

Georgian_Modern_Sort: The Georgian Modern Sort locale.

Georgian_Traditional_100: The Georgian Traditional locale.<104>

German_PhoneBook: The German Phonebook locale.

German_PhoneBook_100: The German Phonebook locale.<105>

Greek: The Greek locale.

Greek_100: The Greek locale.<106>

Hebrew: The Hebrew locale.

Hebrew_100: The Hebrew locale.<107>

Hindi: The Hindi locale.

Hungarian: The Hungarian locale.

Hungarian_100: The Hungarian locale.<108>

Hungarian_Technical: The Hungarian Technical locale.

Hungarian_Technical_100: The Hungarian Technical locale.<109>

Icelandic: The Icelandic locale.

Icelandic_100: The Icelandic locale.<110>

Indic_General_90: The Indic General locale.<111>

Indic_General_100: The Indic General locale.<112>

Inuktitut_100: The Inuktitut locale.<113>

Japanese: The Japanese locale.

Japanese_90: The Japanese locale.<114>

Japanese_100: The Japanese locale.<115>

Japanese_Bushu_Kakusu_100: The Japanese Bushu Kakusu locale.<116>

Japanese_Radical_Stroke_100: The Japanese Radical Stroke locale.<117>

Japanese_Unicode: The Japanese Unicode locale.<118>

Kazakh_90: The Kazakh locale.<119>

Kazakh_100: The Kazakh locale.<120>

Khmer_100: The Khmer locale.<121>

Korean: The Korean locale.

Korean_90: The Korean locale.<122>

Korean_100: The Korean locale.<123>

Korean_Wansung: The Korean Wansung locale.

Korean_Wansung_Unicode: The Korean Wansung Unicode locale.

Lao_100: The Lao locale.<124>

Latin1_General: The Latin1 General locale.

Latin1_General_100: The Latin1 General locale.<125>

Latvian: The Latvian locale.

Latvian_100: The Latvian locale.<126>

Lithuanian: The Lithuanian locale.

Lithuanian_100: The Lithuanian locale.<127>

Lithuanian_Classic: The Lithuanian Classic locale.<128>

Macedonian: The Macedonian locale.

Macedonian_FYROM_90: The Macedonian FYROM locale.<129>

Macedonian_FYROM_100: The Macedonian FYROM locale.<130>

Maltese_100: The Maltese locale.<131>

Maori_100: The Maori locale.<132>

Mapudungan_100: The Mapudungan locale.<133>

Modern_Spanish: The Modern Spanish locale.

Modern_Spanish_100: The Modern Spanish locale.<134>

Mohawk_100: The Mohawk locale.<135>

Mongolian_100: The Mongolian locale.<136>

Nepali_100: The Nepali locale.<137>

Norwegian_100: The Norwegian locale.<138>

Norwegian_Sami_100: The Norwegian Sami locale.<139>

Pashto_100: The Pashto locale.<140>

Persian_100: The Persian locale.<141>

Polish: The Polish locale.

Polish_100: The Polish locale.<142>

Romanian: The Romanian locale.

Romanian_100: The Romanian locale.<143>

Romansh_100: The Romansh locale.<144>

Sami_Norway_100: The Sami Norway locale.<145>

Sami_Sweden_Finland_100: The Sami Sweden Finland locale.<146>

Serbian_Cyrillic_100: The Serbian Cyrillic locale.<147>

Serbian_Latin_100: The Serbian Latin locale.<148>

Slovak: The Slovak locale.

Slovak_100: The Slovak locale.<149>

Slovenian: The Slovenian locale.

Slovenian_100: The Slovenian locale.<150>

Swedish_Finnish_Sami_100: The Swedish Finnish Sami locale.<151>

Syriac_90: The Syriac locale.<152>

Syriac_100: The Syriac locale.<153>

Tatar_90: The Tatar locale.<154>

Tatar_100: The Tatar locale.<155>

Tamazight_100: The Tamazight locale.<156>

Thai: The Thai locale.

Thai_100: The Thai locale.<157>

Tibetan_PRC_100: The Tibetan PRC locale.<158>

Traditional_Spanish: The Traditional Spanish locale.

Traditional_Spanish_100: The Traditional Spanish locale.<159>

Turkish: The Turkish locale.

Turkish_100: The Turkish locale.<160>

Turkmen_100: The Turkmen locale.<161>

Uighur_PRC_100: The Uighur PRC locale.<162>

Ukrainian: The Ukrainian locale.

Ukrainian_100: The Ukrainian locale.<163>

Upper_Sorbian_100: The Upper Sorbian locale.<164>

Urdu_100: The Urdu locale.<165>

Uzbek_Latin_90: The Uzbek Latin locale.<166>

Uzbek_Latin_100: The Uzbek Latin locale.<167>

Vietnamese: The Vietnamese locale.

Vietnamese_100: The Vietnamese locale.<168>

Welsh_100: The Welsh locale.<169>

Yakut_100: The Yakut locale.<170>

Yi_100: The Yi locale.<171>

Following is the parent element of the DataSet.Collation element.

Parent elements

DataSet

The following is the XML Schema definition of the DataSet.Collation element.

 <xsd:element name="Collation" type="xsd:string" minOccurs="0" />