Skip to content

Instantly share code, notes, and snippets.

@tom--

tom--/1-expected.txt

Created September 10, 2019 01:05
Show Gist options
  • Save tom--/0eeb056e8cd074dd414cdf9e1f61af7f to your computer and use it in GitHub Desktop.
Save tom--/0eeb056e8cd074dd414cdf9e1f61af7f to your computer and use it in GitHub Desktop.
Download ZIP
Example of Sphinx collation
Raw
1-expected.txt
MariaDB [(none)]> create schema test collate utf8_general_ci;
Query OK, 1 row affected (0.000 sec)
MariaDB [(none)]> set names utf8;
Query OK, 0 rows affected (0.000 sec)
MariaDB [(none)]> use test
Database changed
MariaDB [test]> create table test (id int not null primary key, name varchar(99) not null);
Query OK, 0 rows affected (0.002 sec)
MariaDB [test]> insert into test (id, name) values (65,'A'),(66,'B'),(67,'C'),(68,'D'),(69,'E'),(70,'F'),(71,'G'),(72,'H'),(73,'I'),(74,'J'),(75,'K'),(76,'L'),(77,'M'),(78,'N'),(79,'O'),(80,'P'),(81,'Q'),(82,'R'),(83,'S'),(84,'T'),(85,'U'),(86,'V'),(87,'W'),(88,'X'),(89,'Y'),(90,'Z'),(97,'a'),(98,'b'),(99,'c'),(100,'d'),(101,'e'),(102,'f'),(103,'g'),(104,'h'),(105,'i'),(106,'j'),(107,'k'),(108,'l'),(109,'m'),(110,'n'),(111,'o'),(112,'p'),(113,'q'),(114,'r'),(115,'s'),(116,'t'),(117,'u'),(118,'v'),(119,'w'),(120,'x'),(121,'y'),(122,'z'),(170,'ª'),(181,'µ'),(186,'º'),(192,'À'),(193,'Á'),(194,'Â'),(195,'Ã'),(196,'Ä'),(197,'Å'),(198,'Æ'),(199,'Ç'),(200,'È'),(201,'É'),(202,'Ê'),(203,'Ë'),(204,'Ì'),(205,'Í'),(206,'Î'),(207,'Ï'),(208,'Ð'),(209,'Ñ'),(210,'Ò'),(211,'Ó'),(212,'Ô'),(213,'Õ'),(214,'Ö'),(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,'ö'),(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,'IJ'),(307,'ij'),(308,'Ĵ'),(309,'ĵ'),(310,'Ķ'),(311,'ķ'),(312,'ĸ'),(313,'Ĺ'),(314,'ĺ'),(315,'Ļ'),(316,'ļ'),(317,'Ľ'),(318,'ľ'),(319,'Ŀ'),(320,'ŀ'),(321,'Ł'),(322,'ł'),(323,'Ń'),(324,'ń'),(325,'Ņ'),(326,'ņ'),(327,'Ň'),(328,'ň'),(329,'ʼn'),(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,'ǀ'),(449,'ǁ'),(450,'ǂ'),(451,'ǃ'),(452,'DŽ'),(453,'Dž'),(454,'dž'),(455,'LJ'),(456,'Lj'),(457,'lj'),(458,'NJ'),(459,'Nj'),(460,'nj'),(461,'Ǎ'),(462,'ǎ'),(463,'Ǐ'),(464,'ǐ'),(465,'Ǒ'),(466,'ǒ'),(467,'Ǔ'),(468,'ǔ'),(469,'Ǖ'),(470,'ǖ'),(471,'Ǘ'),(472,'ǘ'),(473,'Ǚ'),(474,'ǚ'),(475,'Ǜ'),(476,'ǜ'),(477,'ǝ'),(478,'Ǟ'),(479,'ǟ'),(480,'Ǡ'),(481,'ǡ'),(482,'Ǣ'),(483,'ǣ'),(484,'Ǥ'),(485,'ǥ'),(486,'Ǧ'),(487,'ǧ'),(488,'Ǩ'),(489,'ǩ'),(490,'Ǫ'),(491,'ǫ'),(492,'Ǭ'),(493,'ǭ'),(494,'Ǯ'),(495,'ǯ'),(496,'ǰ'),(497,'DZ'),(498,'Dz'),(499,'dz'),(500,'Ǵ'),(501,'ǵ'),(502,'Ƕ'),(503,'Ƿ'),(504,'Ǹ'),(505,'ǹ'),(506,'Ǻ'),(507,'ǻ'),(508,'Ǽ'),(509,'ǽ'),(510,'Ǿ'),(511,'ǿ'),(512,'Ȁ'),(513,'ȁ'),(514,'Ȃ'),(515,'ȃ'),(516,'Ȅ'),(517,'ȅ'),(518,'Ȇ'),(519,'ȇ'),(520,'Ȉ'),(521,'ȉ'),(522,'Ȋ'),(523,'ȋ'),(524,'Ȍ'),(525,'ȍ'),(526,'Ȏ'),(527,'ȏ'),(528,'Ȑ'),(529,'ȑ'),(530,'Ȓ'),(531,'ȓ'),(532,'Ȕ'),(533,'ȕ'),(534,'Ȗ'),(535,'ȗ'),(536,'Ș'),(537,'ș'),(538,'Ț'),(539,'ț'),(540,'Ȝ'),(541,'ȝ'),(542,'Ȟ'),(543,'ȟ'),(544,'Ƞ'),(545,'ȡ'),(546,'Ȣ'),(547,'ȣ'),(548,'Ȥ'),(549,'ȥ'),(550,'Ȧ'),(551,'ȧ'),(552,'Ȩ'),(553,'ȩ'),(554,'Ȫ'),(555,'ȫ'),(556,'Ȭ'),(557,'ȭ'),(558,'Ȯ'),(559,'ȯ'),(560,'Ȱ'),(561,'ȱ'),(562,'Ȳ'),(563,'ȳ'),(564,'ȴ'),(565,'ȵ'),(566,'ȶ'),(567,'ȷ'),(568,'ȸ'),(569,'ȹ'),(570,'Ⱥ'),(571,'Ȼ'),(572,'ȼ'),(573,'Ƚ'),(574,'Ⱦ'),(575,'ȿ'),(576,'ɀ'),(577,'Ɂ'),(578,'ɂ'),(579,'Ƀ'),(580,'Ʉ'),(581,'Ʌ'),(582,'Ɇ'),(583,'ɇ'),(584,'Ɉ'),(585,'ɉ'),(586,'Ɋ'),(587,'ɋ'),(588,'Ɍ'),(589,'ɍ'),(590,'Ɏ'),(591,'ɏ');
Query OK, 453 rows affected (0.002 sec)
Records: 453 Duplicates: 0 Warnings: 0
MariaDB [test]> select group_concat(name order by id) from test group by name;
+-----------------------------------------------------------------------------------------------------------------+
| group_concat(name order by id) |
+-----------------------------------------------------------------------------------------------------------------+
| A,a,À,Á,Â,Ã,Ä,Å,à,á,â,ã,ä,å,Ā,ā,Ă,ă,Ą,ą,Ǎ,ǎ,Ǟ,ǟ,Ǡ,ǡ,Ǻ,ǻ,Ȁ,ȁ,Ȃ,ȃ,Ȧ,ȧ |
| B,b |
| C,c,Ç,ç,Ć,ć,Ĉ,ĉ,Ċ,ċ,Č,č |
| D,d,Ď,ď |
| E,e,È,É,Ê,Ë,è,é,ê,ë,Ē,ē,Ĕ,ĕ,Ė,ė,Ę,ę,Ě,ě,Ȅ,ȅ,Ȇ,ȇ,Ȩ,ȩ |
| F,f |
| G,g,Ĝ,ĝ,Ğ,ğ,Ġ,ġ,Ģ,ģ,Ǧ,ǧ,Ǵ,ǵ |
| H,h,Ĥ,ĥ,Ȟ,ȟ |
| I,i,Ì,Í,Î,Ï,ì,í,î,ï,Ĩ,ĩ,Ī,ī,Ĭ,ĭ,Į,į,İ,ı,Ǐ,ǐ,Ȉ,ȉ,Ȋ,ȋ |
| J,j,Ĵ,ĵ,ǰ |
| K,k,Ķ,ķ,Ǩ,ǩ |
| L,l,Ĺ,ĺ,Ļ,ļ,Ľ,ľ |
| M,m |
| N,n,Ñ,ñ,Ń,ń,Ņ,ņ,Ň,ň,Ǹ,ǹ |
| O,o,Ò,Ó,Ô,Õ,Ö,ò,ó,ô,õ,ö,Ō,ō,Ŏ,ŏ,Ő,ő,Ơ,ơ,Ǒ,ǒ,Ǫ,ǫ,Ǭ,ǭ,Ȍ,ȍ,Ȏ,ȏ,Ȫ,ȫ,Ȭ,ȭ,Ȯ,ȯ,Ȱ,ȱ |
| P,p |
| Q,q |
| R,r,Ŕ,ŕ,Ŗ,ŗ,Ř,ř,Ȑ,ȑ,Ȓ,ȓ |
| S,s,ß,Ś,ś,Ŝ,ŝ,Ş,ş,Š,š,ſ,Ș,ș |
| T,t,Ţ,ţ,Ť,ť,Ț,ț |
| U,u,Ù,Ú,Û,Ü,ù,ú,û,ü,Ũ,ũ,Ū,ū,Ŭ,ŭ,Ů,ů,Ű,ű,Ų,ų,Ư,ư,Ǔ,ǔ,Ǖ,ǖ,Ǘ,ǘ,Ǚ,ǚ,Ǜ,ǜ,Ȕ,ȕ,Ȗ,ȗ |
| V,v |
| W,w,Ŵ,ŵ |
| X,x |
| Y,y,Ý,ý,ÿ,Ŷ,ŷ,Ÿ,Ȳ,ȳ |
| Z,z,Ź,ź,Ż,ż,Ž,ž |
| ª |
| º |
| Æ,æ,Ǣ,ǣ,Ǽ,ǽ |
| Ð,ð |
| Ø,ø,Ǿ,ǿ |
| Þ,þ |
| Đ,đ |
| Ħ,ħ |
| IJ,ij |
| ĸ |
| Ŀ,ŀ |
| Ł,ł |
| ʼn |
| Ŋ,ŋ |
| Œ,œ |
| Ŧ,ŧ |
| ƀ |
| Ɓ |
| Ƃ,ƃ |
| Ƅ,ƅ |
| Ɔ |
| Ƈ,ƈ |
| Ɖ |
| Ɗ |
| Ƌ,ƌ |
| ƍ |
| Ǝ,ǝ |
| Ə |
| Ɛ |
| Ƒ,ƒ |
| Ɠ |
| Ɣ |
| Ɩ |
| Ɨ |
| Ƙ,ƙ |
| ƚ |
| ƛ |
| Ɯ |
| Ɲ |
| ƞ |
| Ɵ |
| Ƣ,ƣ |
| Ƥ,ƥ |
| Ʀ |
| Ƨ,ƨ |
| Ʃ |
| ƪ |
| ƫ |
| Ƭ,ƭ |
| Ʈ |
| Ʊ |
| Ʋ |
| Ƴ,ƴ |
| Ƶ,ƶ |
| Ʒ,Ǯ,ǯ |
| Ƹ,ƹ |
| ƺ |
| ƻ |
| Ƽ,ƽ |
| ƾ |
| ǀ |
| ǁ |
| ǂ |
| ǃ |
| DŽ,Dž,dž |
| LJ,Lj,lj |
| NJ,Nj,nj |
| Ǥ,ǥ |
| DZ,Dz,dz |
| ƕ,Ƕ |
| ƿ,Ƿ |
| Ȝ,ȝ |
| Ƞ |
| ȡ |
| Ȣ,ȣ |
| Ȥ,ȥ |
| ȴ |
| ȵ |
| ȶ |
| ȷ |
| ȸ |
| ȹ |
| Ⱥ |
| Ȼ |
| ȼ |
| Ƚ |
| Ⱦ |
| ȿ |
| ɀ |
| Ɂ |
| ɂ |
| Ƀ |
| Ʉ |
| Ʌ |
| Ɇ |
| ɇ |
| Ɉ |
| ɉ |
| Ɋ |
| ɋ |
| Ɍ |
| ɍ |
| Ɏ |
| ɏ |
| µ |
+-----------------------------------------------------------------------------------------------------------------+
131 rows in set (0.001 sec)
MariaDB [test]> select name, group_concat(id order by id) from test group by name;
+------+--------------------------------------------------------------------------------------------------------------------------------------------------------+
| name | group_concat(id order by id) |
+------+--------------------------------------------------------------------------------------------------------------------------------------------------------+
| A | 65,97,192,193,194,195,196,197,224,225,226,227,228,229,256,257,258,259,260,261,461,462,478,479,480,481,506,507,512,513,514,515,550,551 |
| B | 66,98 |
| Ć | 67,99,199,231,262,263,264,265,266,267,268,269 |
| Ď | 68,100,270,271 |
| Ȅ | 69,101,200,201,202,203,232,233,234,235,274,275,276,277,278,279,280,281,282,283,516,517,518,519,552,553 |
| F | 70,102 |
| Ġ | 71,103,284,285,286,287,288,289,290,291,486,487,500,501 |
| ȟ | 72,104,292,293,542,543 |
| ĩ | 73,105,204,205,206,207,236,237,238,239,296,297,298,299,300,301,302,303,304,305,463,464,520,521,522,523 |
| j | 74,106,308,309,496 |
| ǩ | 75,107,310,311,488,489 |
| ļ | 76,108,313,314,315,316,317,318 |
| m | 77,109 |
| Ǹ | 78,110,209,241,323,324,325,326,327,328,504,505 |
| ŏ | 79,111,210,211,212,213,214,242,243,244,245,246,332,333,334,335,336,337,416,417,465,466,490,491,492,493,524,525,526,527,554,555,556,557,558,559,560,561 |
| P | 80,112 |
| Q | 81,113 |
| Ȑ | 82,114,340,341,342,343,344,345,528,529,530,531 |
| ſ | 83,115,223,346,347,348,349,350,351,352,353,383,536,537 |
| Ţ | 84,116,354,355,356,357,538,539 |
| ư | 85,117,217,218,219,220,249,250,251,252,360,361,362,363,364,365,366,367,368,369,370,371,431,432,467,468,469,470,471,472,473,474,475,476,532,533,534,535 |
| V | 86,118 |
| W | 87,119,372,373 |
| x | 88,120 |
| Ý | 89,121,221,253,255,374,375,376,562,563 |
| Ž | 90,122,377,378,379,380,381,382 |
| ª | 170 |
| º | 186 |
| Ǽ | 198,230,482,483,508,509 |
| ð | 208,240 |
| Ǿ | 216,248,510,511 |
| Þ | 222,254 |
| Đ | 272,273 |
| Ħ | 294,295 |
| IJ | 306,307 |
| ĸ | 312 |
| Ŀ | 319,320 |
| Ł | 321,322 |
| ʼn | 329 |
| Ŋ | 330,331 |
| Π| 338,339 |
| Ŧ | 358,359 |
| ƀ | 384 |
| Ɓ | 385 |
| ƃ | 386,387 |
| Ƅ | 388,389 |
| Ɔ | 390 |
| Ƈ | 391,392 |
| Ɖ | 393 |
| Ɗ | 394 |
| Ƌ | 395,396 |
| ƍ | 397 |
| Ǝ | 398,477 |
| Ə | 399 |
| Ɛ | 400 |
| Ƒ | 401,402 |
| Ɠ | 403 |
| Ɣ | 404 |
| Ɩ | 406 |
| Ɨ | 407 |
| Ƙ | 408,409 |
| ƚ | 410 |
| ƛ | 411 |
| Ɯ | 412 |
| Ɲ | 413 |
| ƞ | 414 |
| Ɵ | 415 |
| Ƣ | 418,419 |
| Ƥ | 420,421 |
| Ʀ | 422 |
| Ƨ | 423,424 |
| Ʃ | 425 |
| ƪ | 426 |
| ƫ | 427 |
| ƭ | 428,429 |
| Ʈ | 430 |
| Ʊ | 433 |
| Ʋ | 434 |
| ƴ | 435,436 |
| ƶ | 437,438 |
| Ʒ | 439,494,495 |
| Ƹ | 440,441 |
| ƺ | 442 |
| ƻ | 443 |
| Ƽ | 444,445 |
| ƾ | 446 |
| ǀ | 448 |
| ǁ | 449 |
| ǂ | 450 |
| ǃ | 451 |
| dž | 452,453,454 |
| Lj | 455,456,457 |
| Nj | 458,459,460 |
| Ǥ | 484,485 |
| Dz | 497,498,499 |
| Ƕ | 405,502 |
| ƿ | 447,503 |
| Ȝ | 540,541 |
| Ƞ | 544 |
| ȡ | 545 |
| Ȣ | 546,547 |
| Ȥ | 548,549 |
| ȴ | 564 |
| ȵ | 565 |
| ȶ | 566 |
| ȷ | 567 |
| ȸ | 568 |
| ȹ | 569 |
| Ⱥ | 570 |
| Ȼ | 571 |
| ȼ | 572 |
| Ƚ | 573 |
| Ⱦ | 574 |
| ȿ | 575 |
| ɀ | 576 |
| Ɂ | 577 |
| ɂ | 578 |
| Ƀ | 579 |
| Ʉ | 580 |
| Ʌ | 581 |
| Ɇ | 582 |
| ɇ | 583 |
| Ɉ | 584 |
| ɉ | 585 |
| Ɋ | 586 |
| ɋ | 587 |
| Ɍ | 588 |
| ɍ | 589 |
| Ɏ | 590 |
| ɏ | 591 |
| µ | 181 |
+------+--------------------------------------------------------------------------------------------------------------------------------------------------------+
131 rows in set (0.001 sec)
MariaDB [test]>
Raw
2-observed.txt
index test
{
type = rt
path = /var/lib/sphinxsearch/data/test
rt_field = name
rt_attr_string = name
}
# Data is already inserted using same SQL as in MariaDB example.
sphinx311> set names utf8;
Query OK, 0 rows affected (0.000 sec)
sphinx311> set COLLATION_CONNECTION = utf8_general_ci;
Query OK, 0 rows affected (0.000 sec)
sphinx311> select name, group_concat(id) from test group by name limit 999;
+------+-------------------------------------------------------------------------------------------------------------------------------------------------+
| name | group_concat(id) |
+------+-------------------------------------------------------------------------------------------------------------------------------------------------+
| A | 65,97 |
| B | 66,98 |
| C | 67,99 |
| D | 68,100 |
| E | 69,101 |
| F | 70,102 |
| G | 71,103 |
| H | 72,104 |
| I | 73,105 |
| J | 74,106 |
| K | 75,107 |
| L | 76,108 |
| M | 77,109 |
| N | 78,110 |
| O | 79,111 |
| P | 80,112 |
| Q | 81,113 |
| R | 82,114 |
| S | 83,115 |
| T | 84,116 |
| U | 85,117 |
| V | 86,118 |
| W | 87,119 |
| X | 88,120 |
| Y | 89,121 |
| Z | 90,122 |
| ª | 170 |
| µ | 181 |
| º | 186 |
| À | 192,193,194,195,196,197,224,225,226,227,228,229,256,257,258,259,260,261,461,462,478,479,480,481,506,507,512,513,514,515,550,551 |
| Æ | 198,230,482,483,508,509 |
| Ç | 199,231,262,263,264,265,266,267,268,269 |
| È | 200,201,202,203,232,233,234,235,274,275,276,277,278,279,280,281,282,283,516,517,518,519,552,553 |
| Ì | 204,205,206,207,236,237,238,239,296,297,298,299,300,301,302,303,304,305,463,464,520,521,522,523 |
| Ð | 208,240 |
| Ñ | 209,241,323,324,325,326,327,328,504,505 |
| Ò | 210,211,212,213,214,242,243,244,245,246,332,333,334,335,336,337,416,417,465,466,490,491,492,493,524,525,526,527,554,555,556,557,558,559,560,561 |
| Ø | 216,248,510,511 |
| Ù | 217,218,219,220,249,250,251,252,360,361,362,363,364,365,366,367,368,369,370,371,431,432,467,468,469,470,471,472,473,474,475,476,532,533,534,535 |
| Ý | 221,253,255,374,375,376,562,563 |
| Þ | 222,254 |
| ß | 223,346,347,348,349,350,351,352,353,383,536,537 |
| Ď | 270,271 |
| Đ | 272,273 |
| Ĝ | 284,285,286,287,288,289,290,291,486,487,500,501 |
| Ĥ | 292,293,542,543 |
| Ħ | 294,295 |
| IJ | 306,307 |
| Ĵ | 308,309,496 |
| Ķ | 310,311,488,489 |
| ĸ | 312 |
| Ĺ | 313,314,315,316,317,318 |
| Ŀ | 319,320 |
| Ł | 321,322 |
| ʼn | 329 |
| Ŋ | 330,331 |
| Π| 338,339 |
| Ŕ | 340,341,342,343,344,345,528,529,530,531 |
| Ţ | 354,355,356,357,538,539 |
| Ŧ | 358,359 |
| Ŵ | 372,373 |
| Ź | 377,378,379,380,381,382 |
| ƀ | 384 |
| Ɓ | 385 |
| Ƃ | 386,387 |
| Ƅ | 388,389 |
| Ɔ | 390 |
| Ƈ | 391,392 |
| Ɖ | 393 |
| Ɗ | 394 |
| Ƌ | 395,396 |
| ƍ | 397 |
| Ǝ | 398,477 |
| Ə | 399 |
| Ɛ | 400 |
| Ƒ | 401,402 |
| Ɠ | 403 |
| Ɣ | 404 |
| ƕ | 405,502 |
| Ɩ | 406 |
| Ɨ | 407 |
| Ƙ | 408,409 |
| ƚ | 410 |
| ƛ | 411 |
| Ɯ | 412 |
| Ɲ | 413 |
| ƞ | 414 |
| Ɵ | 415 |
| Ƣ | 418,419 |
| Ƥ | 420,421 |
| Ʀ | 422 |
| Ƨ | 423,424 |
| Ʃ | 425 |
| ƪ | 426 |
| ƫ | 427 |
| Ƭ | 428,429 |
| Ʈ | 430 |
| Ʊ | 433 |
| Ʋ | 434 |
| Ƴ | 435,436 |
| Ƶ | 437,438 |
| Ʒ | 439,494,495 |
| Ƹ | 440,441 |
| ƺ | 442 |
| ƻ | 443 |
| Ƽ | 444,445 |
| ƾ | 446 |
| ƿ | 447,503 |
| ǀ | 448 |
| ǁ | 449 |
| ǂ | 450 |
| ǃ | 451 |
| DŽ | 452,453,454 |
| LJ | 455,456,457 |
| NJ | 458,459,460 |
| Ǥ | 484,485 |
| DZ | 497,498,499 |
| Ȝ | 540,541 |
| Ƞ | 544 |
| ȡ | 545 |
| Ȣ | 546,547 |
| Ȥ | 548,549 |
| ȴ | 564 |
| ȵ | 565 |
| ȶ | 566 |
| ȷ | 567 |
| ȸ | 568 |
| ȹ | 569 |
| Ⱥ | 570 |
| Ȼ | 571 |
| ȼ | 572 |
| Ƚ | 573 |
| Ⱦ | 574 |
| ȿ | 575 |
| ɀ | 576 |
| Ɂ | 577 |
| ɂ | 578 |
| Ƀ | 579 |
| Ʉ | 580 |
| Ʌ | 581 |
| Ɇ | 582 |
| ɇ | 583 |
| Ɉ | 584 |
| ɉ | 585 |
| Ɋ | 586 |
| ɋ | 587 |
| Ɍ | 588 |
| ɍ | 589 |
| Ɏ | 590 |
| ɏ | 591 |
+------+-------------------------------------------------------------------------------------------------------------------------------------------------+
150 rows in set (0.001 sec)
Raw
3-x-insert.sql
insert into test (id, text) values (65,'A'),(66,'B'),(67,'C'),(68,'D'),(69,'E'),(70,'F'),(71,'G'),(72,'H'),(73,'I'),(74,'J'),(75,'K'),(76,'L'),(77,'M'),(78,'N'),(79,'O'),(80,'P'),(81,'Q'),(82,'R'),(83,'S'),(84,'T'),(85,'U'),(86,'V'),(87,'W'),(88,'X'),(89,'Y'),(90,'Z'),(97,'a'),(98,'b'),(99,'c'),(100,'d'),(101,'e'),(102,'f'),(103,'g'),(104,'h'),(105,'i'),(106,'j'),(107,'k'),(108,'l'),(109,'m'),(110,'n'),(111,'o'),(112,'p'),(113,'q'),(114,'r'),(115,'s'),(116,'t'),(117,'u'),(118,'v'),(119,'w'),(120,'x'),(121,'y'),(122,'z'),(170,'ª'),(181,'µ'),(186,'º'),(192,'À'),(193,'Á'),(194,'Â'),(195,'Ã'),(196,'Ä'),(197,'Å'),(198,'Æ'),(199,'Ç'),(200,'È'),(201,'É'),(202,'Ê'),(203,'Ë'),(204,'Ì'),(205,'Í'),(206,'Î'),(207,'Ï'),(208,'Ð'),(209,'Ñ'),(210,'Ò'),(211,'Ó'),(212,'Ô'),(213,'Õ'),(214,'Ö'),(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,'ö'),(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,'IJ'),(307,'ij'),(308,'Ĵ'),(309,'ĵ'),(310,'Ķ'),(311,'ķ'),(312,'ĸ'),(313,'Ĺ'),(314,'ĺ'),(315,'Ļ'),(316,'ļ'),(317,'Ľ'),(318,'ľ'),(319,'Ŀ'),(320,'ŀ'),(321,'Ł'),(322,'ł'),(323,'Ń'),(324,'ń'),(325,'Ņ'),(326,'ņ'),(327,'Ň'),(328,'ň'),(329,'ʼn'),(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,'ǀ'),(449,'ǁ'),(450,'ǂ'),(451,'ǃ'),(452,'DŽ'),(453,'Dž'),(454,'dž'),(455,'LJ'),(456,'Lj'),(457,'lj'),(458,'NJ'),(459,'Nj'),(460,'nj'),(461,'Ǎ'),(462,'ǎ'),(463,'Ǐ'),(464,'ǐ'),(465,'Ǒ'),(466,'ǒ'),(467,'Ǔ'),(468,'ǔ'),(469,'Ǖ'),(470,'ǖ'),(471,'Ǘ'),(472,'ǘ'),(473,'Ǚ'),(474,'ǚ'),(475,'Ǜ'),(476,'ǜ'),(477,'ǝ'),(478,'Ǟ'),(479,'ǟ'),(480,'Ǡ'),(481,'ǡ'),(482,'Ǣ'),(483,'ǣ'),(484,'Ǥ'),(485,'ǥ'),(486,'Ǧ'),(487,'ǧ'),(488,'Ǩ'),(489,'ǩ'),(490,'Ǫ'),(491,'ǫ'),(492,'Ǭ'),(493,'ǭ'),(494,'Ǯ'),(495,'ǯ'),(496,'ǰ'),(497,'DZ'),(498,'Dz'),(499,'dz'),(500,'Ǵ'),(501,'ǵ'),(502,'Ƕ'),(503,'Ƿ'),(504,'Ǹ'),(505,'ǹ'),(506,'Ǻ'),(507,'ǻ'),(508,'Ǽ'),(509,'ǽ'),(510,'Ǿ'),(511,'ǿ'),(512,'Ȁ'),(513,'ȁ'),(514,'Ȃ'),(515,'ȃ'),(516,'Ȅ'),(517,'ȅ'),(518,'Ȇ'),(519,'ȇ'),(520,'Ȉ'),(521,'ȉ'),(522,'Ȋ'),(523,'ȋ'),(524,'Ȍ'),(525,'ȍ'),(526,'Ȏ'),(527,'ȏ'),(528,'Ȑ'),(529,'ȑ'),(530,'Ȓ'),(531,'ȓ'),(532,'Ȕ'),(533,'ȕ'),(534,'Ȗ'),(535,'ȗ'),(536,'Ș'),(537,'ș'),(538,'Ț'),(539,'ț'),(540,'Ȝ'),(541,'ȝ'),(542,'Ȟ'),(543,'ȟ'),(544,'Ƞ'),(545,'ȡ'),(546,'Ȣ'),(547,'ȣ'),(548,'Ȥ'),(549,'ȥ'),(550,'Ȧ'),(551,'ȧ'),(552,'Ȩ'),(553,'ȩ'),(554,'Ȫ'),(555,'ȫ'),(556,'Ȭ'),(557,'ȭ'),(558,'Ȯ'),(559,'ȯ'),(560,'Ȱ'),(561,'ȱ'),(562,'Ȳ'),(563,'ȳ'),(564,'ȴ'),(565,'ȵ'),(566,'ȶ'),(567,'ȷ'),(568,'ȸ'),(569,'ȹ'),(570,'Ⱥ'),(571,'Ȼ'),(572,'ȼ'),(573,'Ƚ'),(574,'Ⱦ'),(575,'ȿ'),(576,'ɀ'),(577,'Ɂ'),(578,'ɂ'),(579,'Ƀ'),(580,'Ʉ'),(581,'Ʌ'),(582,'Ɇ'),(583,'ɇ'),(584,'Ɉ'),(585,'ɉ'),(586,'Ɋ'),(587,'ɋ'),(588,'Ɍ'),(589,'ɍ'),(590,'Ɏ'),(591,'ɏ');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment