Utilisation d'un between avec une chaine de caractères

**SQLpro** · 05/01/2014, 12h28

Vous oubliez plusieurs choses :
1) la collation fait partie intégrante du type de données. Hélas certains SGBD merdique comme MySQL ne le gère pas de cette manière ce qui rejaillis immanquablement sur les performances (inutilisation des index adéquats).
2) l'encodage des caractères n'a rien à voir avec la collation, ces dernières devant être totalement indépendantes de l'encodage sous jacents des caractères.
3) pour l'application le SGBD transmet des chaines de caractères dépourvue de la collation spécifique (défaut d'impédance). En effet, les langages hôtes ne savent pas la gérer.

Enfin dans le cas de MS SQL Server ce n'est pas 12 collations (relisez ma phrase) mais 12 "dialectes" chinois donnant lieu à 446 collations dont voici la liste :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
name                                                  description
----------------------------------------------------- --------------------------------------------------------------------------------------------------
Chinese_Hong_Kong_Stroke_90_BIN                       binary sort
Chinese_Hong_Kong_Stroke_90_BIN2                      binary code point comparison sort
Chinese_Hong_Kong_Stroke_90_CI_AI                     case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_Hong_Kong_Stroke_90_CI_AI_WS                  case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_Hong_Kong_Stroke_90_CI_AI_KS                  case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_Hong_Kong_Stroke_90_CI_AI_KS_WS               case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_Hong_Kong_Stroke_90_CI_AS                     case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_Hong_Kong_Stroke_90_CI_AS_WS                  case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_Hong_Kong_Stroke_90_CI_AS_KS                  case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_Hong_Kong_Stroke_90_CI_AS_KS_WS               case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Hong_Kong_Stroke_90_CS_AI                     case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_Hong_Kong_Stroke_90_CS_AI_WS                  case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_Hong_Kong_Stroke_90_CS_AI_KS                  case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_Hong_Kong_Stroke_90_CS_AI_KS_WS               case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_Hong_Kong_Stroke_90_CS_AS                     case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_Hong_Kong_Stroke_90_CS_AS_WS                  case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_Hong_Kong_Stroke_90_CS_AS_KS                  case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_Hong_Kong_Stroke_90_CS_AS_KS_WS               case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Hong_Kong_Stroke_90_CI_AI_SC                  case-insent., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Hong_Kong_Stroke_90_CI_AI_WS_SC               case-insent., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Hong_Kong_Stroke_90_CI_AI_KS_SC               case-insent., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Hong_Kong_Stroke_90_CI_AI_KS_WS_SC            case-insent., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Hong_Kong_Stroke_90_CI_AS_SC                  case-insent., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Hong_Kong_Stroke_90_CI_AS_WS_SC               case-insent., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Hong_Kong_Stroke_90_CI_AS_KS_SC               case-insent., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Hong_Kong_Stroke_90_CI_AS_KS_WS_SC            case-insent., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Hong_Kong_Stroke_90_CS_AI_SC                  case-sensit., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Hong_Kong_Stroke_90_CS_AI_WS_SC               case-sensit., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Hong_Kong_Stroke_90_CS_AI_KS_SC               case-sensit., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Hong_Kong_Stroke_90_CS_AI_KS_WS_SC            case-sensit., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Hong_Kong_Stroke_90_CS_AS_SC                  case-sensit., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Hong_Kong_Stroke_90_CS_AS_WS_SC               case-sensit., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Hong_Kong_Stroke_90_CS_AS_KS_SC               case-sensit., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Hong_Kong_Stroke_90_CS_AS_KS_WS_SC            case-sensit., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_PRC_BIN                                       binary sort
Chinese_PRC_BIN2                                      binary code point comparison sort
Chinese_PRC_CI_AI                                     case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_PRC_CI_AI_WS                                  case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_PRC_CI_AI_KS                                  case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_PRC_CI_AI_KS_WS                               case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_PRC_CI_AS                                     case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_PRC_CI_AS_WS                                  case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_PRC_CI_AS_KS                                  case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_PRC_CI_AS_KS_WS                               case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_PRC_CS_AI                                     case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_PRC_CS_AI_WS                                  case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_PRC_CS_AI_KS                                  case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_PRC_CS_AI_KS_WS                               case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_PRC_CS_AS                                     case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_PRC_CS_AS_WS                                  case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_PRC_CS_AS_KS                                  case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_PRC_CS_AS_KS_WS                               case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_PRC_90_BIN                                    binary sort
Chinese_PRC_90_BIN2                                   binary code point comparison sort
Chinese_PRC_90_CI_AI                                  case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_PRC_90_CI_AI_WS                               case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_PRC_90_CI_AI_KS                               case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_PRC_90_CI_AI_KS_WS                            case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_PRC_90_CI_AS                                  case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_PRC_90_CI_AS_WS                               case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_PRC_90_CI_AS_KS                               case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_PRC_90_CI_AS_KS_WS                            case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_PRC_90_CS_AI                                  case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_PRC_90_CS_AI_WS                               case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_PRC_90_CS_AI_KS                               case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_PRC_90_CS_AI_KS_WS                            case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_PRC_90_CS_AS                                  case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_PRC_90_CS_AS_WS                               case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_PRC_90_CS_AS_KS                               case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_PRC_90_CS_AS_KS_WS                            case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_PRC_90_CI_AI_SC                               case-insent., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_PRC_90_CI_AI_WS_SC                            case-insent., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_PRC_90_CI_AI_KS_SC                            case-insent., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_PRC_90_CI_AI_KS_WS_SC                         case-insent., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_PRC_90_CI_AS_SC                               case-insent., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_PRC_90_CI_AS_WS_SC                            case-insent., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_PRC_90_CI_AS_KS_SC                            case-insent., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_PRC_90_CI_AS_KS_WS_SC                         case-insent., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_PRC_90_CS_AI_SC                               case-sensit., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_PRC_90_CS_AI_WS_SC                            case-sensit., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_PRC_90_CS_AI_KS_SC                            case-sensit., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_PRC_90_CS_AI_KS_WS_SC                         case-sensit., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_PRC_90_CS_AS_SC                               case-sensit., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_PRC_90_CS_AS_WS_SC                            case-sensit., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_PRC_90_CS_AS_KS_SC                            case-sensit., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_PRC_90_CS_AS_KS_WS_SC                         case-sensit., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_PRC_Stroke_BIN                                binary sort
Chinese_PRC_Stroke_BIN2                               binary code point comparison sort
Chinese_PRC_Stroke_CI_AI                              case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_PRC_Stroke_CI_AI_WS                           case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_PRC_Stroke_CI_AI_KS                           case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_PRC_Stroke_CI_AI_KS_WS                        case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_PRC_Stroke_CI_AS                              case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_PRC_Stroke_CI_AS_WS                           case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_PRC_Stroke_CI_AS_KS                           case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_PRC_Stroke_CI_AS_KS_WS                        case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_PRC_Stroke_CS_AI                              case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_PRC_Stroke_CS_AI_WS                           case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_PRC_Stroke_CS_AI_KS                           case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_PRC_Stroke_CS_AI_KS_WS                        case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_PRC_Stroke_CS_AS                              case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_PRC_Stroke_CS_AS_WS                           case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_PRC_Stroke_CS_AS_KS                           case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_PRC_Stroke_CS_AS_KS_WS                        case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_PRC_Stroke_90_BIN                             binary sort
Chinese_PRC_Stroke_90_BIN2                            binary code point comparison sort
Chinese_PRC_Stroke_90_CI_AI                           case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_PRC_Stroke_90_CI_AI_WS                        case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_PRC_Stroke_90_CI_AI_KS                        case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_PRC_Stroke_90_CI_AI_KS_WS                     case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_PRC_Stroke_90_CI_AS                           case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_PRC_Stroke_90_CI_AS_WS                        case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_PRC_Stroke_90_CI_AS_KS                        case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_PRC_Stroke_90_CI_AS_KS_WS                     case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_PRC_Stroke_90_CS_AI                           case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_PRC_Stroke_90_CS_AI_WS                        case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_PRC_Stroke_90_CS_AI_KS                        case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_PRC_Stroke_90_CS_AI_KS_WS                     case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_PRC_Stroke_90_CS_AS                           case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_PRC_Stroke_90_CS_AS_WS                        case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_PRC_Stroke_90_CS_AS_KS                        case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_PRC_Stroke_90_CS_AS_KS_WS                     case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_PRC_Stroke_90_CI_AI_SC                        case-insent., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_PRC_Stroke_90_CI_AI_WS_SC                     case-insent., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_PRC_Stroke_90_CI_AI_KS_SC                     case-insent., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_PRC_Stroke_90_CI_AI_KS_WS_SC                  case-insent., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_PRC_Stroke_90_CI_AS_SC                        case-insent., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_PRC_Stroke_90_CI_AS_WS_SC                     case-insent., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_PRC_Stroke_90_CI_AS_KS_SC                     case-insent., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_PRC_Stroke_90_CI_AS_KS_WS_SC                  case-insent., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_PRC_Stroke_90_CS_AI_SC                        case-sensit., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_PRC_Stroke_90_CS_AI_WS_SC                     case-sensit., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_PRC_Stroke_90_CS_AI_KS_SC                     case-sensit., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_PRC_Stroke_90_CS_AI_KS_WS_SC                  case-sensit., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_PRC_Stroke_90_CS_AS_SC                        case-sensit., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_PRC_Stroke_90_CS_AS_WS_SC                     case-sensit., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_PRC_Stroke_90_CS_AS_KS_SC                     case-sensit., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_PRC_Stroke_90_CS_AS_KS_WS_SC                  case-sensit., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Simplified_Pinyin_100_BIN                     binary sort
Chinese_Simplified_Pinyin_100_BIN2                    binary code point comparison sort
Chinese_Simplified_Pinyin_100_CI_AI                   case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_Simplified_Pinyin_100_CI_AI_WS                case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_Simplified_Pinyin_100_CI_AI_KS                case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_Simplified_Pinyin_100_CI_AI_KS_WS             case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_Simplified_Pinyin_100_CI_AS                   case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_Simplified_Pinyin_100_CI_AS_WS                case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_Simplified_Pinyin_100_CI_AS_KS                case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_Simplified_Pinyin_100_CI_AS_KS_WS             case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Simplified_Pinyin_100_CS_AI                   case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_Simplified_Pinyin_100_CS_AI_WS                case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_Simplified_Pinyin_100_CS_AI_KS                case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_Simplified_Pinyin_100_CS_AI_KS_WS             case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_Simplified_Pinyin_100_CS_AS                   case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_Simplified_Pinyin_100_CS_AS_WS                case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_Simplified_Pinyin_100_CS_AS_KS                case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_Simplified_Pinyin_100_CS_AS_KS_WS             case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Simplified_Pinyin_100_CI_AI_SC                case-insent., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Simplified_Pinyin_100_CI_AI_WS_SC             case-insent., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Simplified_Pinyin_100_CI_AI_KS_SC             case-insent., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Simplified_Pinyin_100_CI_AI_KS_WS_SC          case-insent., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Simplified_Pinyin_100_CI_AS_SC                case-insent., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Simplified_Pinyin_100_CI_AS_WS_SC             case-insent., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Simplified_Pinyin_100_CI_AS_KS_SC             case-insent., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Simplified_Pinyin_100_CI_AS_KS_WS_SC          case-insent., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Simplified_Pinyin_100_CS_AI_SC                case-sensit., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Simplified_Pinyin_100_CS_AI_WS_SC             case-sensit., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Simplified_Pinyin_100_CS_AI_KS_SC             case-sensit., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Simplified_Pinyin_100_CS_AI_KS_WS_SC          case-sensit., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Simplified_Pinyin_100_CS_AS_SC                case-sensit., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Simplified_Pinyin_100_CS_AS_WS_SC             case-sensit., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Simplified_Pinyin_100_CS_AS_KS_SC             case-sensit., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Simplified_Pinyin_100_CS_AS_KS_WS_SC          case-sensit., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Simplified_Stroke_Order_100_BIN               binary sort
Chinese_Simplified_Stroke_Order_100_BIN2              binary code point comparison sort
Chinese_Simplified_Stroke_Order_100_CI_AI             case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_Simplified_Stroke_Order_100_CI_AI_WS          case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_Simplified_Stroke_Order_100_CI_AI_KS          case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_Simplified_Stroke_Order_100_CI_AI_KS_WS       case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_Simplified_Stroke_Order_100_CI_AS             case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_Simplified_Stroke_Order_100_CI_AS_WS          case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_Simplified_Stroke_Order_100_CI_AS_KS          case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_Simplified_Stroke_Order_100_CI_AS_KS_WS       case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Simplified_Stroke_Order_100_CS_AI             case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_Simplified_Stroke_Order_100_CS_AI_WS          case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_Simplified_Stroke_Order_100_CS_AI_KS          case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_Simplified_Stroke_Order_100_CS_AI_KS_WS       case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_Simplified_Stroke_Order_100_CS_AS             case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_Simplified_Stroke_Order_100_CS_AS_WS          case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_Simplified_Stroke_Order_100_CS_AS_KS          case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_Simplified_Stroke_Order_100_CS_AS_KS_WS       case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Simplified_Stroke_Order_100_CI_AI_SC          case-insent., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Simplified_Stroke_Order_100_CI_AI_WS_SC       case-insent., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Simplified_Stroke_Order_100_CI_AI_KS_SC       case-insent., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Simplified_Stroke_Order_100_CI_AI_KS_WS_SC    case-insent., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Simplified_Stroke_Order_100_CI_AS_SC          case-insent., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Simplified_Stroke_Order_100_CI_AS_WS_SC       case-insent., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Simplified_Stroke_Order_100_CI_AS_KS_SC       case-insent., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Simplified_Stroke_Order_100_CI_AS_KS_WS_SC    case-insent., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Simplified_Stroke_Order_100_CS_AI_SC          case-sensit., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Simplified_Stroke_Order_100_CS_AI_WS_SC       case-sensit., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Simplified_Stroke_Order_100_CS_AI_KS_SC       case-sensit., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Simplified_Stroke_Order_100_CS_AI_KS_WS_SC    case-sensit., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Simplified_Stroke_Order_100_CS_AS_SC          case-sensit., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Simplified_Stroke_Order_100_CS_AS_WS_SC       case-sensit., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Simplified_Stroke_Order_100_CS_AS_KS_SC       case-sensit., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Simplified_Stroke_Order_100_CS_AS_KS_WS_SC    case-sensit., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Taiwan_Bopomofo_BIN                           binary sort
Chinese_Taiwan_Bopomofo_BIN2                          binary code point comparison sort
Chinese_Taiwan_Bopomofo_CI_AI                         case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_Taiwan_Bopomofo_CI_AI_WS                      case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_Taiwan_Bopomofo_CI_AI_KS                      case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_Taiwan_Bopomofo_CI_AI_KS_WS                   case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_Taiwan_Bopomofo_CI_AS                         case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_Taiwan_Bopomofo_CI_AS_WS                      case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_Taiwan_Bopomofo_CI_AS_KS                      case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_Taiwan_Bopomofo_CI_AS_KS_WS                   case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Taiwan_Bopomofo_CS_AI                         case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_Taiwan_Bopomofo_CS_AI_WS                      case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_Taiwan_Bopomofo_CS_AI_KS                      case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_Taiwan_Bopomofo_CS_AI_KS_WS                   case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_Taiwan_Bopomofo_CS_AS                         case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_Taiwan_Bopomofo_CS_AS_WS                      case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_Taiwan_Bopomofo_CS_AS_KS                      case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_Taiwan_Bopomofo_CS_AS_KS_WS                   case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Taiwan_Bopomofo_90_BIN                        binary sort
Chinese_Taiwan_Bopomofo_90_BIN2                       binary code point comparison sort
Chinese_Taiwan_Bopomofo_90_CI_AI                      case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_Taiwan_Bopomofo_90_CI_AI_WS                   case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_Taiwan_Bopomofo_90_CI_AI_KS                   case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_Taiwan_Bopomofo_90_CI_AI_KS_WS                case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_Taiwan_Bopomofo_90_CI_AS                      case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_Taiwan_Bopomofo_90_CI_AS_WS                   case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_Taiwan_Bopomofo_90_CI_AS_KS                   case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_Taiwan_Bopomofo_90_CI_AS_KS_WS                case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Taiwan_Bopomofo_90_CS_AI                      case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_Taiwan_Bopomofo_90_CS_AI_WS                   case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_Taiwan_Bopomofo_90_CS_AI_KS                   case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_Taiwan_Bopomofo_90_CS_AI_KS_WS                case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_Taiwan_Bopomofo_90_CS_AS                      case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_Taiwan_Bopomofo_90_CS_AS_WS                   case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_Taiwan_Bopomofo_90_CS_AS_KS                   case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_Taiwan_Bopomofo_90_CS_AS_KS_WS                case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Taiwan_Bopomofo_90_CI_AI_SC                   case-insent., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Taiwan_Bopomofo_90_CI_AI_WS_SC                case-insent., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Taiwan_Bopomofo_90_CI_AI_KS_SC                case-insent., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Taiwan_Bopomofo_90_CI_AI_KS_WS_SC             case-insent., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Taiwan_Bopomofo_90_CI_AS_SC                   case-insent., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Taiwan_Bopomofo_90_CI_AS_WS_SC                case-insent., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Taiwan_Bopomofo_90_CI_AS_KS_SC                case-insent., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Taiwan_Bopomofo_90_CI_AS_KS_WS_SC             case-insent., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Taiwan_Bopomofo_90_CS_AI_SC                   case-sensit., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Taiwan_Bopomofo_90_CS_AI_WS_SC                case-sensit., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Taiwan_Bopomofo_90_CS_AI_KS_SC                case-sensit., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Taiwan_Bopomofo_90_CS_AI_KS_WS_SC             case-sensit., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Taiwan_Bopomofo_90_CS_AS_SC                   case-sensit., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Taiwan_Bopomofo_90_CS_AS_WS_SC                case-sensit., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Taiwan_Bopomofo_90_CS_AS_KS_SC                case-sensit., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Taiwan_Bopomofo_90_CS_AS_KS_WS_SC             case-sensit., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Taiwan_Stroke_BIN                             binary sort
Chinese_Taiwan_Stroke_BIN2                            binary code point comparison sort
Chinese_Taiwan_Stroke_CI_AI                           case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_Taiwan_Stroke_CI_AI_WS                        case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_Taiwan_Stroke_CI_AI_KS                        case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_Taiwan_Stroke_CI_AI_KS_WS                     case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_Taiwan_Stroke_CI_AS                           case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_Taiwan_Stroke_CI_AS_WS                        case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_Taiwan_Stroke_CI_AS_KS                        case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_Taiwan_Stroke_CI_AS_KS_WS                     case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Taiwan_Stroke_CS_AI                           case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_Taiwan_Stroke_CS_AI_WS                        case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_Taiwan_Stroke_CS_AI_KS                        case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_Taiwan_Stroke_CS_AI_KS_WS                     case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_Taiwan_Stroke_CS_AS                           case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_Taiwan_Stroke_CS_AS_WS                        case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_Taiwan_Stroke_CS_AS_KS                        case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_Taiwan_Stroke_CS_AS_KS_WS                     case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Taiwan_Stroke_90_BIN                          binary sort
Chinese_Taiwan_Stroke_90_BIN2                         binary code point comparison sort
Chinese_Taiwan_Stroke_90_CI_AI                        case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_Taiwan_Stroke_90_CI_AI_WS                     case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_Taiwan_Stroke_90_CI_AI_KS                     case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_Taiwan_Stroke_90_CI_AI_KS_WS                  case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_Taiwan_Stroke_90_CI_AS                        case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_Taiwan_Stroke_90_CI_AS_WS                     case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_Taiwan_Stroke_90_CI_AS_KS                     case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_Taiwan_Stroke_90_CI_AS_KS_WS                  case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Taiwan_Stroke_90_CS_AI                        case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_Taiwan_Stroke_90_CS_AI_WS                     case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_Taiwan_Stroke_90_CS_AI_KS                     case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_Taiwan_Stroke_90_CS_AI_KS_WS                  case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_Taiwan_Stroke_90_CS_AS                        case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_Taiwan_Stroke_90_CS_AS_WS                     case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_Taiwan_Stroke_90_CS_AS_KS                     case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_Taiwan_Stroke_90_CS_AS_KS_WS                  case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Taiwan_Stroke_90_CI_AI_SC                     case-insent., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Taiwan_Stroke_90_CI_AI_WS_SC                  case-insent., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Taiwan_Stroke_90_CI_AI_KS_SC                  case-insent., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Taiwan_Stroke_90_CI_AI_KS_WS_SC               case-insent., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Taiwan_Stroke_90_CI_AS_SC                     case-insent., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Taiwan_Stroke_90_CI_AS_WS_SC                  case-insent., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Taiwan_Stroke_90_CI_AS_KS_SC                  case-insent., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Taiwan_Stroke_90_CI_AS_KS_WS_SC               case-insent., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Taiwan_Stroke_90_CS_AI_SC                     case-sensit., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Taiwan_Stroke_90_CS_AI_WS_SC                  case-sensit., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Taiwan_Stroke_90_CS_AI_KS_SC                  case-sensit., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Taiwan_Stroke_90_CS_AI_KS_WS_SC               case-sensit., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Taiwan_Stroke_90_CS_AS_SC                     case-sensit., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Taiwan_Stroke_90_CS_AS_WS_SC                  case-sensit., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Taiwan_Stroke_90_CS_AS_KS_SC                  case-sensit., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Taiwan_Stroke_90_CS_AS_KS_WS_SC               case-sensit., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Bopomofo_100_BIN                  binary sort
Chinese_Traditional_Bopomofo_100_BIN2                 binary code point comparison sort
Chinese_Traditional_Bopomofo_100_CI_AI                case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_Traditional_Bopomofo_100_CI_AI_WS             case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_Traditional_Bopomofo_100_CI_AI_KS             case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_Traditional_Bopomofo_100_CI_AI_KS_WS          case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_Traditional_Bopomofo_100_CI_AS                case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_Traditional_Bopomofo_100_CI_AS_WS             case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_Traditional_Bopomofo_100_CI_AS_KS             case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_Traditional_Bopomofo_100_CI_AS_KS_WS          case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Traditional_Bopomofo_100_CS_AI                case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_Traditional_Bopomofo_100_CS_AI_WS             case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_Traditional_Bopomofo_100_CS_AI_KS             case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_Traditional_Bopomofo_100_CS_AI_KS_WS          case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_Traditional_Bopomofo_100_CS_AS                case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_Traditional_Bopomofo_100_CS_AS_WS             case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_Traditional_Bopomofo_100_CS_AS_KS             case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_Traditional_Bopomofo_100_CS_AS_KS_WS          case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Traditional_Bopomofo_100_CI_AI_SC             case-insent., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Bopomofo_100_CI_AI_WS_SC          case-insent., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Bopomofo_100_CI_AI_KS_SC          case-insent., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Bopomofo_100_CI_AI_KS_WS_SC       case-insent., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Bopomofo_100_CI_AS_SC             case-insent., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Bopomofo_100_CI_AS_WS_SC          case-insent., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Bopomofo_100_CI_AS_KS_SC          case-insent., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Bopomofo_100_CI_AS_KS_WS_SC       case-insent., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Bopomofo_100_CS_AI_SC             case-sensit., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Bopomofo_100_CS_AI_WS_SC          case-sensit., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Bopomofo_100_CS_AI_KS_SC          case-sensit., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Bopomofo_100_CS_AI_KS_WS_SC       case-sensit., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Bopomofo_100_CS_AS_SC             case-sensit., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Bopomofo_100_CS_AS_WS_SC          case-sensit., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Bopomofo_100_CS_AS_KS_SC          case-sensit., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Bopomofo_100_CS_AS_KS_WS_SC       case-sensit., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Pinyin_100_BIN                    binary sort
Chinese_Traditional_Pinyin_100_BIN2                   binary code point comparison sort
Chinese_Traditional_Pinyin_100_CI_AI                  case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_Traditional_Pinyin_100_CI_AI_WS               case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_Traditional_Pinyin_100_CI_AI_KS               case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_Traditional_Pinyin_100_CI_AI_KS_WS            case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_Traditional_Pinyin_100_CI_AS                  case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_Traditional_Pinyin_100_CI_AS_WS               case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_Traditional_Pinyin_100_CI_AS_KS               case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_Traditional_Pinyin_100_CI_AS_KS_WS            case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Traditional_Pinyin_100_CS_AI                  case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_Traditional_Pinyin_100_CS_AI_WS               case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_Traditional_Pinyin_100_CS_AI_KS               case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_Traditional_Pinyin_100_CS_AI_KS_WS            case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_Traditional_Pinyin_100_CS_AS                  case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_Traditional_Pinyin_100_CS_AS_WS               case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_Traditional_Pinyin_100_CS_AS_KS               case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_Traditional_Pinyin_100_CS_AS_KS_WS            case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Traditional_Pinyin_100_CI_AI_SC               case-insent., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Pinyin_100_CI_AI_WS_SC            case-insent., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Pinyin_100_CI_AI_KS_SC            case-insent., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Pinyin_100_CI_AI_KS_WS_SC         case-insent., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Pinyin_100_CI_AS_SC               case-insent., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Pinyin_100_CI_AS_WS_SC            case-insent., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Pinyin_100_CI_AS_KS_SC            case-insent., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Pinyin_100_CI_AS_KS_WS_SC         case-insent., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Pinyin_100_CS_AI_SC               case-sensit., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Pinyin_100_CS_AI_WS_SC            case-sensit., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Pinyin_100_CS_AI_KS_SC            case-sensit., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Pinyin_100_CS_AI_KS_WS_SC         case-sensit., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Pinyin_100_CS_AS_SC               case-sensit., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Pinyin_100_CS_AS_WS_SC            case-sensit., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Pinyin_100_CS_AS_KS_SC            case-sensit., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Pinyin_100_CS_AS_KS_WS_SC         case-sensit., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Count_100_BIN              binary sort
Chinese_Traditional_Stroke_Count_100_BIN2             binary code point comparison sort
Chinese_Traditional_Stroke_Count_100_CI_AI            case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_Traditional_Stroke_Count_100_CI_AI_WS         case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_Traditional_Stroke_Count_100_CI_AI_KS         case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_Traditional_Stroke_Count_100_CI_AI_KS_WS      case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_Traditional_Stroke_Count_100_CI_AS            case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_Traditional_Stroke_Count_100_CI_AS_WS         case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_Traditional_Stroke_Count_100_CI_AS_KS         case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_Traditional_Stroke_Count_100_CI_AS_KS_WS      case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Traditional_Stroke_Count_100_CS_AI            case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_Traditional_Stroke_Count_100_CS_AI_WS         case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_Traditional_Stroke_Count_100_CS_AI_KS         case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_Traditional_Stroke_Count_100_CS_AI_KS_WS      case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_Traditional_Stroke_Count_100_CS_AS            case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_Traditional_Stroke_Count_100_CS_AS_WS         case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_Traditional_Stroke_Count_100_CS_AS_KS         case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_Traditional_Stroke_Count_100_CS_AS_KS_WS      case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Traditional_Stroke_Count_100_CI_AI_SC         case-insent., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Stroke_Count_100_CI_AI_WS_SC      case-insent., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Count_100_CI_AI_KS_SC      case-insent., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Stroke_Count_100_CI_AI_KS_WS_SC   case-insent., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Count_100_CI_AS_SC         case-insent., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Stroke_Count_100_CI_AS_WS_SC      case-insent., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Count_100_CI_AS_KS_SC      case-insent., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Stroke_Count_100_CI_AS_KS_WS_SC   case-insent., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Count_100_CS_AI_SC         case-sensit., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Stroke_Count_100_CS_AI_WS_SC      case-sensit., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Count_100_CS_AI_KS_SC      case-sensit., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Stroke_Count_100_CS_AI_KS_WS_SC   case-sensit., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Count_100_CS_AS_SC         case-sensit., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Stroke_Count_100_CS_AS_WS_SC      case-sensit., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Count_100_CS_AS_KS_SC      case-sensit., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Stroke_Count_100_CS_AS_KS_WS_SC   case-sensit., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Order_100_BIN              binary sort
Chinese_Traditional_Stroke_Order_100_BIN2             binary code point comparison sort
Chinese_Traditional_Stroke_Order_100_CI_AI            case-insent., accent-insent., kanatype-insent., width-insent.
Chinese_Traditional_Stroke_Order_100_CI_AI_WS         case-insent., accent-insent., kanatype-insent., width-sensit.
Chinese_Traditional_Stroke_Order_100_CI_AI_KS         case-insent., accent-insent., kanatype-sensit., width-insent.
Chinese_Traditional_Stroke_Order_100_CI_AI_KS_WS      case-insent., accent-insent., kanatype-sensit., width-sensit.
Chinese_Traditional_Stroke_Order_100_CI_AS            case-insent., accent-sensit., kanatype-insent., width-insent.
Chinese_Traditional_Stroke_Order_100_CI_AS_WS         case-insent., accent-sensit., kanatype-insent., width-sensit.
Chinese_Traditional_Stroke_Order_100_CI_AS_KS         case-insent., accent-sensit., kanatype-sensit., width-insent.
Chinese_Traditional_Stroke_Order_100_CI_AS_KS_WS      case-insent., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Traditional_Stroke_Order_100_CS_AI            case-sensit., accent-insent., kanatype-insent., width-insent.
Chinese_Traditional_Stroke_Order_100_CS_AI_WS         case-sensit., accent-insent., kanatype-insent., width-sensit.
Chinese_Traditional_Stroke_Order_100_CS_AI_KS         case-sensit., accent-insent., kanatype-sensit., width-insent.
Chinese_Traditional_Stroke_Order_100_CS_AI_KS_WS      case-sensit., accent-insent., kanatype-sensit., width-sensit.
Chinese_Traditional_Stroke_Order_100_CS_AS            case-sensit., accent-sensit., kanatype-insent., width-insent.
Chinese_Traditional_Stroke_Order_100_CS_AS_WS         case-sensit., accent-sensit., kanatype-insent., width-sensit.
Chinese_Traditional_Stroke_Order_100_CS_AS_KS         case-sensit., accent-sensit., kanatype-sensit., width-insent.
Chinese_Traditional_Stroke_Order_100_CS_AS_KS_WS      case-sensit., accent-sensit., kanatype-sensit., width-sensit.
Chinese_Traditional_Stroke_Order_100_CI_AI_SC         case-insent., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Stroke_Order_100_CI_AI_WS_SC      case-insent., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Order_100_CI_AI_KS_SC      case-insent., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Stroke_Order_100_CI_AI_KS_WS_SC   case-insent., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Order_100_CI_AS_SC         case-insent., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Stroke_Order_100_CI_AS_WS_SC      case-insent., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Order_100_CI_AS_KS_SC      case-insent., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Stroke_Order_100_CI_AS_KS_WS_SC   case-insent., accent-sensit., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Order_100_CS_AI_SC         case-sensit., accent-insent., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Stroke_Order_100_CS_AI_WS_SC      case-sensit., accent-insent., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Order_100_CS_AI_KS_SC      case-sensit., accent-insent., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Stroke_Order_100_CS_AI_KS_WS_SC   case-sensit., accent-insent., kanatype-sensit., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Order_100_CS_AS_SC         case-sensit., accent-sensit., kanatype-insent., width-insent., supplementary characters
Chinese_Traditional_Stroke_Order_100_CS_AS_WS_SC      case-sensit., accent-sensit., kanatype-insent., width-sensit., supplementary characters
Chinese_Traditional_Stroke_Order_100_CS_AS_KS_SC      case-sensit., accent-sensit., kanatype-sensit., width-insent., supplementary characters
Chinese_Traditional_Stroke_Order_100_CS_AS_KS_WS_SC   case-sensit., accent-sensit., kanatype-sensit., width-sensit., supplementary characters

A +

**bstevy** · 15/01/2015, 05h28

Je ne m'attendais pas à déchaîner autant les passions avec cette simple question. Merci en tout cas pour toutes ces explications, c’était super instructif ^^

**SQLpro** · 19/01/2015, 10h54

Envoyé par Yanika_bzh

Je demandais votre logique de comparaison, pas forcément celle de votre SGBD
Votre SGBD ne compare en aucune facon @ ou ~ mais bien leur transcodification, ce qui n a absolument rien a voir. L algèbre permet des comparaisons qui ne sont pas les memes.
Pour vous le prouver, pouvez vous me dire quelle regle de comparaison vous appliquez pour classer ces 3 termes alpha numériques :
我, 你, 他. Et demandez a votre SGBD si il est applique la même règle...

Vous vous méprenez totalzment... En effet, les SGBDR (pas les merdouilles comme MySQmerde...) utilisent les collations et non les jeux de caractères pour effectuer les comparaisons.

À titre informatif voici ce que donne SQL Server avec les différentes collations traitant les idéogrammes que vous nous avez donné dans les différentes collations interprétant du chinois (je m'en suis arrêtez là, mais j'aurais pu vous montrer ce que cela donnait avec les 4000 collations différentes de SQL Server !!!)

Code x :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
COMPARE     COLLATION
----------- ---------------------------------------------------
1           Chinese_Hong_Kong_Stroke_90_BIN
1           Chinese_Hong_Kong_Stroke_90_BIN2
1           Chinese_Hong_Kong_Stroke_90_CI_AI
1           Chinese_Hong_Kong_Stroke_90_CI_AI_WS
1           Chinese_Hong_Kong_Stroke_90_CI_AI_KS
1           Chinese_Hong_Kong_Stroke_90_CI_AI_KS_WS
1           Chinese_Hong_Kong_Stroke_90_CI_AS
1           Chinese_Hong_Kong_Stroke_90_CI_AS_WS
1           Chinese_Hong_Kong_Stroke_90_CI_AS_KS
1           Chinese_Hong_Kong_Stroke_90_CI_AS_KS_WS
1           Chinese_Hong_Kong_Stroke_90_CS_AI
1           Chinese_Hong_Kong_Stroke_90_CS_AI_WS
1           Chinese_Hong_Kong_Stroke_90_CS_AI_KS
1           Chinese_Hong_Kong_Stroke_90_CS_AI_KS_WS
1           Chinese_Hong_Kong_Stroke_90_CS_AS
1           Chinese_Hong_Kong_Stroke_90_CS_AS_WS
1           Chinese_Hong_Kong_Stroke_90_CS_AS_KS
1           Chinese_Hong_Kong_Stroke_90_CS_AS_KS_WS
1           Chinese_Hong_Kong_Stroke_90_CI_AI_SC
1           Chinese_Hong_Kong_Stroke_90_CI_AI_WS_SC
1           Chinese_Hong_Kong_Stroke_90_CI_AI_KS_SC
1           Chinese_Hong_Kong_Stroke_90_CI_AI_KS_WS_SC
1           Chinese_Hong_Kong_Stroke_90_CI_AS_SC
1           Chinese_Hong_Kong_Stroke_90_CI_AS_WS_SC
1           Chinese_Hong_Kong_Stroke_90_CI_AS_KS_SC
1           Chinese_Hong_Kong_Stroke_90_CI_AS_KS_WS_SC
1           Chinese_Hong_Kong_Stroke_90_CS_AI_SC
1           Chinese_Hong_Kong_Stroke_90_CS_AI_WS_SC
1           Chinese_Hong_Kong_Stroke_90_CS_AI_KS_SC
1           Chinese_Hong_Kong_Stroke_90_CS_AI_KS_WS_SC
1           Chinese_Hong_Kong_Stroke_90_CS_AS_SC
1           Chinese_Hong_Kong_Stroke_90_CS_AS_WS_SC
1           Chinese_Hong_Kong_Stroke_90_CS_AS_KS_SC
1           Chinese_Hong_Kong_Stroke_90_CS_AS_KS_WS_SC
1           Chinese_PRC_BIN
1           Chinese_PRC_BIN2
0           Chinese_PRC_CI_AI
0           Chinese_PRC_CI_AI_WS
0           Chinese_PRC_CI_AI_KS
0           Chinese_PRC_CI_AI_KS_WS
0           Chinese_PRC_CI_AS
0           Chinese_PRC_CI_AS_WS
0           Chinese_PRC_CI_AS_KS
0           Chinese_PRC_CI_AS_KS_WS
0           Chinese_PRC_CS_AI
0           Chinese_PRC_CS_AI_WS
0           Chinese_PRC_CS_AI_KS
0           Chinese_PRC_CS_AI_KS_WS
0           Chinese_PRC_CS_AS
0           Chinese_PRC_CS_AS_WS
0           Chinese_PRC_CS_AS_KS
0           Chinese_PRC_CS_AS_KS_WS
1           Chinese_PRC_90_BIN
1           Chinese_PRC_90_BIN2
0           Chinese_PRC_90_CI_AI
0           Chinese_PRC_90_CI_AI_WS
0           Chinese_PRC_90_CI_AI_KS
0           Chinese_PRC_90_CI_AI_KS_WS
0           Chinese_PRC_90_CI_AS
0           Chinese_PRC_90_CI_AS_WS
0           Chinese_PRC_90_CI_AS_KS
0           Chinese_PRC_90_CI_AS_KS_WS
0           Chinese_PRC_90_CS_AI
0           Chinese_PRC_90_CS_AI_WS
0           Chinese_PRC_90_CS_AI_KS
0           Chinese_PRC_90_CS_AI_KS_WS
0           Chinese_PRC_90_CS_AS
0           Chinese_PRC_90_CS_AS_WS
0           Chinese_PRC_90_CS_AS_KS
0           Chinese_PRC_90_CS_AS_KS_WS
0           Chinese_PRC_90_CI_AI_SC
0           Chinese_PRC_90_CI_AI_WS_SC
0           Chinese_PRC_90_CI_AI_KS_SC
0           Chinese_PRC_90_CI_AI_KS_WS_SC
0           Chinese_PRC_90_CI_AS_SC
0           Chinese_PRC_90_CI_AS_WS_SC
0           Chinese_PRC_90_CI_AS_KS_SC
0           Chinese_PRC_90_CI_AS_KS_WS_SC
0           Chinese_PRC_90_CS_AI_SC
0           Chinese_PRC_90_CS_AI_WS_SC
0           Chinese_PRC_90_CS_AI_KS_SC
0           Chinese_PRC_90_CS_AI_KS_WS_SC
0           Chinese_PRC_90_CS_AS_SC
0           Chinese_PRC_90_CS_AS_WS_SC
0           Chinese_PRC_90_CS_AS_KS_SC
0           Chinese_PRC_90_CS_AS_KS_WS_SC
1           Chinese_PRC_Stroke_BIN
1           Chinese_PRC_Stroke_BIN2
1           Chinese_PRC_Stroke_CI_AI
1           Chinese_PRC_Stroke_CI_AI_WS
1           Chinese_PRC_Stroke_CI_AI_KS
1           Chinese_PRC_Stroke_CI_AI_KS_WS
1           Chinese_PRC_Stroke_CI_AS
1           Chinese_PRC_Stroke_CI_AS_WS
1           Chinese_PRC_Stroke_CI_AS_KS
1           Chinese_PRC_Stroke_CI_AS_KS_WS
1           Chinese_PRC_Stroke_CS_AI
1           Chinese_PRC_Stroke_CS_AI_WS
1           Chinese_PRC_Stroke_CS_AI_KS
1           Chinese_PRC_Stroke_CS_AI_KS_WS
1           Chinese_PRC_Stroke_CS_AS
1           Chinese_PRC_Stroke_CS_AS_WS
1           Chinese_PRC_Stroke_CS_AS_KS
1           Chinese_PRC_Stroke_CS_AS_KS_WS
1           Chinese_PRC_Stroke_90_BIN
1           Chinese_PRC_Stroke_90_BIN2
1           Chinese_PRC_Stroke_90_CI_AI
1           Chinese_PRC_Stroke_90_CI_AI_WS
1           Chinese_PRC_Stroke_90_CI_AI_KS
1           Chinese_PRC_Stroke_90_CI_AI_KS_WS
1           Chinese_PRC_Stroke_90_CI_AS
1           Chinese_PRC_Stroke_90_CI_AS_WS
1           Chinese_PRC_Stroke_90_CI_AS_KS
1           Chinese_PRC_Stroke_90_CI_AS_KS_WS
1           Chinese_PRC_Stroke_90_CS_AI
1           Chinese_PRC_Stroke_90_CS_AI_WS
1           Chinese_PRC_Stroke_90_CS_AI_KS
1           Chinese_PRC_Stroke_90_CS_AI_KS_WS
1           Chinese_PRC_Stroke_90_CS_AS
1           Chinese_PRC_Stroke_90_CS_AS_WS
1           Chinese_PRC_Stroke_90_CS_AS_KS
1           Chinese_PRC_Stroke_90_CS_AS_KS_WS
1           Chinese_PRC_Stroke_90_CI_AI_SC
1           Chinese_PRC_Stroke_90_CI_AI_WS_SC
1           Chinese_PRC_Stroke_90_CI_AI_KS_SC
1           Chinese_PRC_Stroke_90_CI_AI_KS_WS_SC
1           Chinese_PRC_Stroke_90_CI_AS_SC
1           Chinese_PRC_Stroke_90_CI_AS_WS_SC
1           Chinese_PRC_Stroke_90_CI_AS_KS_SC
1           Chinese_PRC_Stroke_90_CI_AS_KS_WS_SC
1           Chinese_PRC_Stroke_90_CS_AI_SC
1           Chinese_PRC_Stroke_90_CS_AI_WS_SC
1           Chinese_PRC_Stroke_90_CS_AI_KS_SC
1           Chinese_PRC_Stroke_90_CS_AI_KS_WS_SC
1           Chinese_PRC_Stroke_90_CS_AS_SC
1           Chinese_PRC_Stroke_90_CS_AS_WS_SC
1           Chinese_PRC_Stroke_90_CS_AS_KS_SC
1           Chinese_PRC_Stroke_90_CS_AS_KS_WS_SC
1           Chinese_Simplified_Pinyin_100_BIN
1           Chinese_Simplified_Pinyin_100_BIN2
0           Chinese_Simplified_Pinyin_100_CI_AI
0           Chinese_Simplified_Pinyin_100_CI_AI_WS
0           Chinese_Simplified_Pinyin_100_CI_AI_KS
0           Chinese_Simplified_Pinyin_100_CI_AI_KS_WS
0           Chinese_Simplified_Pinyin_100_CI_AS
0           Chinese_Simplified_Pinyin_100_CI_AS_WS
0           Chinese_Simplified_Pinyin_100_CI_AS_KS
0           Chinese_Simplified_Pinyin_100_CI_AS_KS_WS
0           Chinese_Simplified_Pinyin_100_CS_AI
0           Chinese_Simplified_Pinyin_100_CS_AI_WS
0           Chinese_Simplified_Pinyin_100_CS_AI_KS
0           Chinese_Simplified_Pinyin_100_CS_AI_KS_WS
0           Chinese_Simplified_Pinyin_100_CS_AS
0           Chinese_Simplified_Pinyin_100_CS_AS_WS
0           Chinese_Simplified_Pinyin_100_CS_AS_KS
0           Chinese_Simplified_Pinyin_100_CS_AS_KS_WS
0           Chinese_Simplified_Pinyin_100_CI_AI_SC
0           Chinese_Simplified_Pinyin_100_CI_AI_WS_SC
0           Chinese_Simplified_Pinyin_100_CI_AI_KS_SC
0           Chinese_Simplified_Pinyin_100_CI_AI_KS_WS_SC
0           Chinese_Simplified_Pinyin_100_CI_AS_SC
0           Chinese_Simplified_Pinyin_100_CI_AS_WS_SC
0           Chinese_Simplified_Pinyin_100_CI_AS_KS_SC
0           Chinese_Simplified_Pinyin_100_CI_AS_KS_WS_SC
0           Chinese_Simplified_Pinyin_100_CS_AI_SC
0           Chinese_Simplified_Pinyin_100_CS_AI_WS_SC
0           Chinese_Simplified_Pinyin_100_CS_AI_KS_SC
0           Chinese_Simplified_Pinyin_100_CS_AI_KS_WS_SC
0           Chinese_Simplified_Pinyin_100_CS_AS_SC
0           Chinese_Simplified_Pinyin_100_CS_AS_WS_SC
0           Chinese_Simplified_Pinyin_100_CS_AS_KS_SC
0           Chinese_Simplified_Pinyin_100_CS_AS_KS_WS_SC
1           Chinese_Simplified_Stroke_Order_100_BIN
1           Chinese_Simplified_Stroke_Order_100_BIN2
0           Chinese_Simplified_Stroke_Order_100_CI_AI
0           Chinese_Simplified_Stroke_Order_100_CI_AI_WS
0           Chinese_Simplified_Stroke_Order_100_CI_AI_KS
0           Chinese_Simplified_Stroke_Order_100_CI_AI_KS_WS
0           Chinese_Simplified_Stroke_Order_100_CI_AS
0           Chinese_Simplified_Stroke_Order_100_CI_AS_WS
0           Chinese_Simplified_Stroke_Order_100_CI_AS_KS
0           Chinese_Simplified_Stroke_Order_100_CI_AS_KS_WS
0           Chinese_Simplified_Stroke_Order_100_CS_AI
0           Chinese_Simplified_Stroke_Order_100_CS_AI_WS
0           Chinese_Simplified_Stroke_Order_100_CS_AI_KS
0           Chinese_Simplified_Stroke_Order_100_CS_AI_KS_WS
0           Chinese_Simplified_Stroke_Order_100_CS_AS
0           Chinese_Simplified_Stroke_Order_100_CS_AS_WS
0           Chinese_Simplified_Stroke_Order_100_CS_AS_KS
0           Chinese_Simplified_Stroke_Order_100_CS_AS_KS_WS
0           Chinese_Simplified_Stroke_Order_100_CI_AI_SC
0           Chinese_Simplified_Stroke_Order_100_CI_AI_WS_SC
0           Chinese_Simplified_Stroke_Order_100_CI_AI_KS_SC
0           Chinese_Simplified_Stroke_Order_100_CI_AI_KS_WS_SC
0           Chinese_Simplified_Stroke_Order_100_CI_AS_SC
0           Chinese_Simplified_Stroke_Order_100_CI_AS_WS_SC
0           Chinese_Simplified_Stroke_Order_100_CI_AS_KS_SC
0           Chinese_Simplified_Stroke_Order_100_CI_AS_KS_WS_SC
0           Chinese_Simplified_Stroke_Order_100_CS_AI_SC
0           Chinese_Simplified_Stroke_Order_100_CS_AI_WS_SC
0           Chinese_Simplified_Stroke_Order_100_CS_AI_KS_SC
0           Chinese_Simplified_Stroke_Order_100_CS_AI_KS_WS_SC
0           Chinese_Simplified_Stroke_Order_100_CS_AS_SC
0           Chinese_Simplified_Stroke_Order_100_CS_AS_WS_SC
0           Chinese_Simplified_Stroke_Order_100_CS_AS_KS_SC
0           Chinese_Simplified_Stroke_Order_100_CS_AS_KS_WS_SC
1           Chinese_Taiwan_Bopomofo_BIN
1           Chinese_Taiwan_Bopomofo_BIN2
1           Chinese_Taiwan_Bopomofo_CI_AI
1           Chinese_Taiwan_Bopomofo_CI_AI_WS
1           Chinese_Taiwan_Bopomofo_CI_AI_KS
1           Chinese_Taiwan_Bopomofo_CI_AI_KS_WS
1           Chinese_Taiwan_Bopomofo_CI_AS
1           Chinese_Taiwan_Bopomofo_CI_AS_WS
1           Chinese_Taiwan_Bopomofo_CI_AS_KS
1           Chinese_Taiwan_Bopomofo_CI_AS_KS_WS
1           Chinese_Taiwan_Bopomofo_CS_AI
1           Chinese_Taiwan_Bopomofo_CS_AI_WS
1           Chinese_Taiwan_Bopomofo_CS_AI_KS
1           Chinese_Taiwan_Bopomofo_CS_AI_KS_WS
1           Chinese_Taiwan_Bopomofo_CS_AS
1           Chinese_Taiwan_Bopomofo_CS_AS_WS
1           Chinese_Taiwan_Bopomofo_CS_AS_KS
1           Chinese_Taiwan_Bopomofo_CS_AS_KS_WS
1           Chinese_Taiwan_Bopomofo_90_BIN
1           Chinese_Taiwan_Bopomofo_90_BIN2
1           Chinese_Taiwan_Bopomofo_90_CI_AI
1           Chinese_Taiwan_Bopomofo_90_CI_AI_WS
1           Chinese_Taiwan_Bopomofo_90_CI_AI_KS
1           Chinese_Taiwan_Bopomofo_90_CI_AI_KS_WS
1           Chinese_Taiwan_Bopomofo_90_CI_AS
1           Chinese_Taiwan_Bopomofo_90_CI_AS_WS
1           Chinese_Taiwan_Bopomofo_90_CI_AS_KS
1           Chinese_Taiwan_Bopomofo_90_CI_AS_KS_WS
1           Chinese_Taiwan_Bopomofo_90_CS_AI
1           Chinese_Taiwan_Bopomofo_90_CS_AI_WS
1           Chinese_Taiwan_Bopomofo_90_CS_AI_KS
1           Chinese_Taiwan_Bopomofo_90_CS_AI_KS_WS
1           Chinese_Taiwan_Bopomofo_90_CS_AS
1           Chinese_Taiwan_Bopomofo_90_CS_AS_WS
1           Chinese_Taiwan_Bopomofo_90_CS_AS_KS
1           Chinese_Taiwan_Bopomofo_90_CS_AS_KS_WS
1           Chinese_Taiwan_Bopomofo_90_CI_AI_SC
1           Chinese_Taiwan_Bopomofo_90_CI_AI_WS_SC
1           Chinese_Taiwan_Bopomofo_90_CI_AI_KS_SC
1           Chinese_Taiwan_Bopomofo_90_CI_AI_KS_WS_SC
1           Chinese_Taiwan_Bopomofo_90_CI_AS_SC
1           Chinese_Taiwan_Bopomofo_90_CI_AS_WS_SC
1           Chinese_Taiwan_Bopomofo_90_CI_AS_KS_SC
1           Chinese_Taiwan_Bopomofo_90_CI_AS_KS_WS_SC
1           Chinese_Taiwan_Bopomofo_90_CS_AI_SC
1           Chinese_Taiwan_Bopomofo_90_CS_AI_WS_SC
1           Chinese_Taiwan_Bopomofo_90_CS_AI_KS_SC
1           Chinese_Taiwan_Bopomofo_90_CS_AI_KS_WS_SC
1           Chinese_Taiwan_Bopomofo_90_CS_AS_SC
1           Chinese_Taiwan_Bopomofo_90_CS_AS_WS_SC
1           Chinese_Taiwan_Bopomofo_90_CS_AS_KS_SC
1           Chinese_Taiwan_Bopomofo_90_CS_AS_KS_WS_SC
1           Chinese_Taiwan_Stroke_BIN
1           Chinese_Taiwan_Stroke_BIN2
1           Chinese_Taiwan_Stroke_CI_AI
1           Chinese_Taiwan_Stroke_CI_AI_WS
1           Chinese_Taiwan_Stroke_CI_AI_KS
1           Chinese_Taiwan_Stroke_CI_AI_KS_WS
1           Chinese_Taiwan_Stroke_CI_AS
1           Chinese_Taiwan_Stroke_CI_AS_WS
1           Chinese_Taiwan_Stroke_CI_AS_KS
1           Chinese_Taiwan_Stroke_CI_AS_KS_WS
1           Chinese_Taiwan_Stroke_CS_AI
1           Chinese_Taiwan_Stroke_CS_AI_WS
1           Chinese_Taiwan_Stroke_CS_AI_KS
1           Chinese_Taiwan_Stroke_CS_AI_KS_WS
1           Chinese_Taiwan_Stroke_CS_AS
1           Chinese_Taiwan_Stroke_CS_AS_WS
1           Chinese_Taiwan_Stroke_CS_AS_KS
1           Chinese_Taiwan_Stroke_CS_AS_KS_WS
1           Chinese_Taiwan_Stroke_90_BIN
1           Chinese_Taiwan_Stroke_90_BIN2
1           Chinese_Taiwan_Stroke_90_CI_AI
1           Chinese_Taiwan_Stroke_90_CI_AI_WS
1           Chinese_Taiwan_Stroke_90_CI_AI_KS
1           Chinese_Taiwan_Stroke_90_CI_AI_KS_WS
1           Chinese_Taiwan_Stroke_90_CI_AS
1           Chinese_Taiwan_Stroke_90_CI_AS_WS
1           Chinese_Taiwan_Stroke_90_CI_AS_KS
1           Chinese_Taiwan_Stroke_90_CI_AS_KS_WS
1           Chinese_Taiwan_Stroke_90_CS_AI
1           Chinese_Taiwan_Stroke_90_CS_AI_WS
1           Chinese_Taiwan_Stroke_90_CS_AI_KS
1           Chinese_Taiwan_Stroke_90_CS_AI_KS_WS
1           Chinese_Taiwan_Stroke_90_CS_AS
1           Chinese_Taiwan_Stroke_90_CS_AS_WS
1           Chinese_Taiwan_Stroke_90_CS_AS_KS
1           Chinese_Taiwan_Stroke_90_CS_AS_KS_WS
1           Chinese_Taiwan_Stroke_90_CI_AI_SC
1           Chinese_Taiwan_Stroke_90_CI_AI_WS_SC
1           Chinese_Taiwan_Stroke_90_CI_AI_KS_SC
1           Chinese_Taiwan_Stroke_90_CI_AI_KS_WS_SC
1           Chinese_Taiwan_Stroke_90_CI_AS_SC
1           Chinese_Taiwan_Stroke_90_CI_AS_WS_SC
1           Chinese_Taiwan_Stroke_90_CI_AS_KS_SC
1           Chinese_Taiwan_Stroke_90_CI_AS_KS_WS_SC
1           Chinese_Taiwan_Stroke_90_CS_AI_SC
1           Chinese_Taiwan_Stroke_90_CS_AI_WS_SC
1           Chinese_Taiwan_Stroke_90_CS_AI_KS_SC
1           Chinese_Taiwan_Stroke_90_CS_AI_KS_WS_SC
1           Chinese_Taiwan_Stroke_90_CS_AS_SC
1           Chinese_Taiwan_Stroke_90_CS_AS_WS_SC
1           Chinese_Taiwan_Stroke_90_CS_AS_KS_SC
1           Chinese_Taiwan_Stroke_90_CS_AS_KS_WS_SC
1           Chinese_Traditional_Bopomofo_100_BIN
1           Chinese_Traditional_Bopomofo_100_BIN2
1           Chinese_Traditional_Bopomofo_100_CI_AI
1           Chinese_Traditional_Bopomofo_100_CI_AI_WS
1           Chinese_Traditional_Bopomofo_100_CI_AI_KS
1           Chinese_Traditional_Bopomofo_100_CI_AI_KS_WS
1           Chinese_Traditional_Bopomofo_100_CI_AS
1           Chinese_Traditional_Bopomofo_100_CI_AS_WS
1           Chinese_Traditional_Bopomofo_100_CI_AS_KS
1           Chinese_Traditional_Bopomofo_100_CI_AS_KS_WS
1           Chinese_Traditional_Bopomofo_100_CS_AI
1           Chinese_Traditional_Bopomofo_100_CS_AI_WS
1           Chinese_Traditional_Bopomofo_100_CS_AI_KS
1           Chinese_Traditional_Bopomofo_100_CS_AI_KS_WS
1           Chinese_Traditional_Bopomofo_100_CS_AS
1           Chinese_Traditional_Bopomofo_100_CS_AS_WS
1           Chinese_Traditional_Bopomofo_100_CS_AS_KS
1           Chinese_Traditional_Bopomofo_100_CS_AS_KS_WS
1           Chinese_Traditional_Bopomofo_100_CI_AI_SC
1           Chinese_Traditional_Bopomofo_100_CI_AI_WS_SC
1           Chinese_Traditional_Bopomofo_100_CI_AI_KS_SC
1           Chinese_Traditional_Bopomofo_100_CI_AI_KS_WS_SC
1           Chinese_Traditional_Bopomofo_100_CI_AS_SC
1           Chinese_Traditional_Bopomofo_100_CI_AS_WS_SC
1           Chinese_Traditional_Bopomofo_100_CI_AS_KS_SC
1           Chinese_Traditional_Bopomofo_100_CI_AS_KS_WS_SC
1           Chinese_Traditional_Bopomofo_100_CS_AI_SC
1           Chinese_Traditional_Bopomofo_100_CS_AI_WS_SC
1           Chinese_Traditional_Bopomofo_100_CS_AI_KS_SC
1           Chinese_Traditional_Bopomofo_100_CS_AI_KS_WS_SC
1           Chinese_Traditional_Bopomofo_100_CS_AS_SC
1           Chinese_Traditional_Bopomofo_100_CS_AS_WS_SC
1           Chinese_Traditional_Bopomofo_100_CS_AS_KS_SC
1           Chinese_Traditional_Bopomofo_100_CS_AS_KS_WS_SC
1           Chinese_Traditional_Pinyin_100_BIN
1           Chinese_Traditional_Pinyin_100_BIN2
0           Chinese_Traditional_Pinyin_100_CI_AI
0           Chinese_Traditional_Pinyin_100_CI_AI_WS
0           Chinese_Traditional_Pinyin_100_CI_AI_KS
0           Chinese_Traditional_Pinyin_100_CI_AI_KS_WS
0           Chinese_Traditional_Pinyin_100_CI_AS
0           Chinese_Traditional_Pinyin_100_CI_AS_WS
0           Chinese_Traditional_Pinyin_100_CI_AS_KS
0           Chinese_Traditional_Pinyin_100_CI_AS_KS_WS
0           Chinese_Traditional_Pinyin_100_CS_AI
0           Chinese_Traditional_Pinyin_100_CS_AI_WS
0           Chinese_Traditional_Pinyin_100_CS_AI_KS
0           Chinese_Traditional_Pinyin_100_CS_AI_KS_WS
0           Chinese_Traditional_Pinyin_100_CS_AS
0           Chinese_Traditional_Pinyin_100_CS_AS_WS
0           Chinese_Traditional_Pinyin_100_CS_AS_KS
0           Chinese_Traditional_Pinyin_100_CS_AS_KS_WS
0           Chinese_Traditional_Pinyin_100_CI_AI_SC
0           Chinese_Traditional_Pinyin_100_CI_AI_WS_SC
0           Chinese_Traditional_Pinyin_100_CI_AI_KS_SC
0           Chinese_Traditional_Pinyin_100_CI_AI_KS_WS_SC
0           Chinese_Traditional_Pinyin_100_CI_AS_SC
0           Chinese_Traditional_Pinyin_100_CI_AS_WS_SC
0           Chinese_Traditional_Pinyin_100_CI_AS_KS_SC
0           Chinese_Traditional_Pinyin_100_CI_AS_KS_WS_SC
0           Chinese_Traditional_Pinyin_100_CS_AI_SC
0           Chinese_Traditional_Pinyin_100_CS_AI_WS_SC
0           Chinese_Traditional_Pinyin_100_CS_AI_KS_SC
0           Chinese_Traditional_Pinyin_100_CS_AI_KS_WS_SC
0           Chinese_Traditional_Pinyin_100_CS_AS_SC
0           Chinese_Traditional_Pinyin_100_CS_AS_WS_SC
0           Chinese_Traditional_Pinyin_100_CS_AS_KS_SC
0           Chinese_Traditional_Pinyin_100_CS_AS_KS_WS_SC
1           Chinese_Traditional_Stroke_Count_100_BIN
1           Chinese_Traditional_Stroke_Count_100_BIN2
1           Chinese_Traditional_Stroke_Count_100_CI_AI
1           Chinese_Traditional_Stroke_Count_100_CI_AI_WS
1           Chinese_Traditional_Stroke_Count_100_CI_AI_KS
1           Chinese_Traditional_Stroke_Count_100_CI_AI_KS_WS
1           Chinese_Traditional_Stroke_Count_100_CI_AS
1           Chinese_Traditional_Stroke_Count_100_CI_AS_WS
1           Chinese_Traditional_Stroke_Count_100_CI_AS_KS
1           Chinese_Traditional_Stroke_Count_100_CI_AS_KS_WS
1           Chinese_Traditional_Stroke_Count_100_CS_AI
1           Chinese_Traditional_Stroke_Count_100_CS_AI_WS
1           Chinese_Traditional_Stroke_Count_100_CS_AI_KS
1           Chinese_Traditional_Stroke_Count_100_CS_AI_KS_WS
1           Chinese_Traditional_Stroke_Count_100_CS_AS
1           Chinese_Traditional_Stroke_Count_100_CS_AS_WS
1           Chinese_Traditional_Stroke_Count_100_CS_AS_KS
1           Chinese_Traditional_Stroke_Count_100_CS_AS_KS_WS
1           Chinese_Traditional_Stroke_Count_100_CI_AI_SC
1           Chinese_Traditional_Stroke_Count_100_CI_AI_WS_SC
1           Chinese_Traditional_Stroke_Count_100_CI_AI_KS_SC
1           Chinese_Traditional_Stroke_Count_100_CI_AI_KS_WS_SC
1           Chinese_Traditional_Stroke_Count_100_CI_AS_SC
1           Chinese_Traditional_Stroke_Count_100_CI_AS_WS_SC
1           Chinese_Traditional_Stroke_Count_100_CI_AS_KS_SC
1           Chinese_Traditional_Stroke_Count_100_CI_AS_KS_WS_SC
1           Chinese_Traditional_Stroke_Count_100_CS_AI_SC
1           Chinese_Traditional_Stroke_Count_100_CS_AI_WS_SC
1           Chinese_Traditional_Stroke_Count_100_CS_AI_KS_SC
1           Chinese_Traditional_Stroke_Count_100_CS_AI_KS_WS_SC
1           Chinese_Traditional_Stroke_Count_100_CS_AS_SC
1           Chinese_Traditional_Stroke_Count_100_CS_AS_WS_SC
1           Chinese_Traditional_Stroke_Count_100_CS_AS_KS_SC
1           Chinese_Traditional_Stroke_Count_100_CS_AS_KS_WS_SC
1           Chinese_Traditional_Stroke_Order_100_BIN
1           Chinese_Traditional_Stroke_Order_100_BIN2
0           Chinese_Traditional_Stroke_Order_100_CI_AI
0           Chinese_Traditional_Stroke_Order_100_CI_AI_WS
0           Chinese_Traditional_Stroke_Order_100_CI_AI_KS
0           Chinese_Traditional_Stroke_Order_100_CI_AI_KS_WS
0           Chinese_Traditional_Stroke_Order_100_CI_AS
0           Chinese_Traditional_Stroke_Order_100_CI_AS_WS
0           Chinese_Traditional_Stroke_Order_100_CI_AS_KS
0           Chinese_Traditional_Stroke_Order_100_CI_AS_KS_WS
0           Chinese_Traditional_Stroke_Order_100_CS_AI
0           Chinese_Traditional_Stroke_Order_100_CS_AI_WS
0           Chinese_Traditional_Stroke_Order_100_CS_AI_KS
0           Chinese_Traditional_Stroke_Order_100_CS_AI_KS_WS
0           Chinese_Traditional_Stroke_Order_100_CS_AS
0           Chinese_Traditional_Stroke_Order_100_CS_AS_WS
0           Chinese_Traditional_Stroke_Order_100_CS_AS_KS
0           Chinese_Traditional_Stroke_Order_100_CS_AS_KS_WS
0           Chinese_Traditional_Stroke_Order_100_CI_AI_SC
0           Chinese_Traditional_Stroke_Order_100_CI_AI_WS_SC
0           Chinese_Traditional_Stroke_Order_100_CI_AI_KS_SC
0           Chinese_Traditional_Stroke_Order_100_CI_AI_KS_WS_SC
0           Chinese_Traditional_Stroke_Order_100_CI_AS_SC
0           Chinese_Traditional_Stroke_Order_100_CI_AS_WS_SC
0           Chinese_Traditional_Stroke_Order_100_CI_AS_KS_SC
0           Chinese_Traditional_Stroke_Order_100_CI_AS_KS_WS_SC
0           Chinese_Traditional_Stroke_Order_100_CS_AI_SC
0           Chinese_Traditional_Stroke_Order_100_CS_AI_WS_SC
0           Chinese_Traditional_Stroke_Order_100_CS_AI_KS_SC
0           Chinese_Traditional_Stroke_Order_100_CS_AI_KS_WS_SC
0           Chinese_Traditional_Stroke_Order_100_CS_AS_SC
0           Chinese_Traditional_Stroke_Order_100_CS_AS_WS_SC
0           Chinese_Traditional_Stroke_Order_100_CS_AS_KS_SC
0           Chinese_Traditional_Stroke_Order_100_CS_AS_KS_WS_SC

À titre informatif, voici comment a été générée la requête qui m'a permis de vous donner ce résultat :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
SELECT N'SELECT CASE WHEN N''我'' > N''你'' COLLATE ' + name + N' AND N''你'' > N''他'' COLLATE ' + name + N' THEN 1 ELSE 0 END AS COMPARE, ''' + name + N''' AS COLLATION UNION ALL '
FROM sys.fn_helpcollations() WHERE UPPER(name) LIKE '%CHINESE%'

A +

Utilisation d'un between avec une chaine de caractères

Langage SQL

Discussions similaires

Partager

Partager