Bug #6505 Wrong sorting order in croat.conf and cp-1250.conf
Submitted: 8 Nov 2004 20:05 Modified: 9 May 2005 0:37
Reporter: Dubravko Penezic Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.22 and before OS:Any (all)
Assigned to: Alexander Barkov CPU Architecture:Any
Tags: corruption, myisam

[8 Nov 2004 20:05] Dubravko Penezic
Description:
Sorting order for croatian character still didnt fixed.

Version 4.1.x latin2.xml have same problem, and cp-1250.xml doesnt have at all sorting order.

How to repeat:
Create table with croatian character and make order by that field

Suggested fix:
* Croatian Sorting Order acording Babic's "Hrvatski pravopis"
  - character with ASCII code less then 41(Hex) a sorted on respekting
    order to thay ASCII value
  - charcter upper and lower case are same
  - character with aditional elements which are not part of Croatian
    alphabet come after same character without that elements
  - every aditional character after 41(Hex) whicha are not part of
    alphabet come after same character without that elements
  - every aditional character after 41(Hex) whicha are not part of
    alphabet (special chracter, signe) a sorted by thay ASCII position and
    come after last alphabet character
  - ISO-8859-2 mostly use on Unix/Linux platform
  - CP-1250 implemented on Microsoft Win platform
  - according actual Croatian law ISO 8859-2 is recomedation

# sort_order array (must have 256 elements) Croataian ISO-8859-2
  00  01  02  03  04  05  06  07  08  09  0A  0B  0C  0D  0E  0F
  10  11  12  13  14  15  16  17  18  19  1A  1B  1C  1D  1E  1F
  20  21  22  23  24  25  26  27  28  29  2A  2B  2C  2D  2E  2F
  30  31  32  33  34  35  36  37  38  39  3A  3B  3C  3D  3E  3F
  40  41  43  44  48  4B  4D  4E  4F  50  52  53  54  56  57  59
  5B  5C  5D  5F  62  64  66  67  68  69  6B  6E  6F  70  71  72
  73  41  43  44  48  4B  4D  4E  4F  50  52  53  54  56  57  59
  5B  5C  5D  5F  62  64  66  67  68  69  6B  7B  7C  7D  7E  7F
  73  41  43  44  48  4B  4D  4E  4F  50  52  53  54  56  57  59
  5B  5C  5D  5F  62  64  66  67  68  69  6B  7B  7C  7D  7E  7F
  80  81  82  83  84  85  86  87  88  89  8A  8B  8C  8D  8E  8F
  90  91  92  93  94  95  96  97  98  99  9A  9B  9C  9D  9E  9F
  A0  42  A2  55  A4  55  60  A7  A8  61  60  63  6C  AD  6D  6C
  B0  42  B2  55  B4  55  60  B7  B8  61  60  63  6C  BD  6D  6C
  5E  42  42  42  42  55  47  45  46  4C  4C  4C  4C  51  51  49
  4A  58  58  5A  5A  5A  5A  D7  5E  65  65  65  65  6A  63  60
  5E  42  42  42  42  55  47  45  46  4C  4C  4C  4C  51  51  49
  4A  58  58  5A  5A  5A  5A  F7  5E  65  65  65  65  6A  63  FF

# sort_order array (must have 256 elements) Croataian CP-1250
  00  01  02  03  04  05  06  07  08  09  0A  0B  0C  0D  0E  0F
  10  11  12  13  14  15  16  17  18  19  1A  1B  1C  1D  1E  1F
  20  21  22  23  24  25  26  27  28  29  2A  2B  2C  2D  2E  2F
  30  31  32  33  34  35  36  37  38  39  3A  3B  3C  3D  3E  3F
  40  41  43  44  48  4B  4D  4E  4F  50  52  53  54  56  57  59
  5B  5C  5D  5F  62  64  66  67  68  69  6B  6E  6F  70  71  72
  73  41  43  44  48  4B  4D  4E  4F  50  52  53  54  56  57  59
  5B  5C  5D  5F  62  64  66  67  68  69  6B  7B  7C  7D  7E  7F
  80  81  82  83  84  85  86  87  88  89  61  8B  60  63  6D  6C
  90  91  92  93  94  95  96  97  98  99  61  9B  60  63  6D  6C
  A0  42  A2  55  A4  42  60  A7  A8  61  60  63  6C  AD  6D  6C
  B0  42  B2  55  B4  55  60  B7  B8  42  60  63  55  BD  55  6C
  5E  42  42  42  42  55  47  45  46  4C  4C  4C  4C  51  51  49
  4A  58  58  5A  5A  5A  5A  D7  5E  65  65  65  65  6A  63  60
  5E  42  42  42  42  55  47  45  46  4C  4C  4C  4C  51  51  49
  4A  58  58  5A  5A  5A  5A  F7  5E  65  65  65  65  6A  63  FF
[6 May 2005 15:16] Alexander Barkov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Fixed in 4.1.12:
- latin2_croatian_ci was fixed
- cp1250_croatian_ci was added
[9 May 2005 0:37] Paul DuBois
Noted in 4.1.12 changelog.