MySQL Bugs: #35808: utf8 hungarian collation not part of the utf8 charset?

Bug #35808	utf8 hungarian collation not part of the utf8 charset?
Submitted:	3 Apr 2008 15:56	Modified:	14 Aug 2008 3:41
Reporter:	Laszlo KAROLYI	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Charsets	Severity:	S3 (Non-critical)
Version:	5.1.23	OS:	FreeBSD
Assigned to:	Alexander Barkov	CPU Architecture:	Any
Tags:	utf8 charset hungarian collation

Description:
Hi,

i would like to compile the mysql-server and client with default collation utf8_hungarian_ci, which (in my opinion) should be the part of the utf8 charset. When i try to configure, the confogure script writes:

Collation utf8_hungarian_ci is not valid for character set utf8.
Valid collations are: utf8_general_ci utf8_bin utf8_czech_ci utf8_danish_ci utf8_esperanto_ci utf8_estonian_ci utf8_icelandic_ci utf8_latvian_ci utf8_lithuanian_ci utf8_persian_ci utf8_polish_ci utf8_romanian_ci utf8_slovak_ci utf8_slovenian_ci utf8_spanish2_ci utf8_spanish_ci utf8_swedish_ci utf8_turkish_ci utf8_unicode_ci.

I think the utf8 charset should contain the general hungarian collation too. In this way, i can only compile utf8_general_ci with it.

How to repeat:
issue the following on FreeBSD in /usr/ports/databases/mysql51-server:

make WITH_CHARSET=utf8 WITH_COLLATION=utf8_general_ci WITH_LINUXTHREADS=yes WITH_XCHARSET=all

Suggested fix:
Put the utf8_hungarian_ci into the utf8 charset.

sorry, i mistyped. the right command line is:

make WITH_CHARSET=utf8 WITH_COLLATION=utf8_hungarian_ci WITH_LINUXTHREADS=yes
WITH_XCHARSET=all

the original line was the working one, copy-pasted.

Verified as described with 5.1-bk-tree:

$ ./configure --with-charset=utf8 --with-collation=utf8_hungarian_ci --prefix=/home/myuser/mysql51bk

checking whether make sets $(MAKE)... yes
checking "character sets"... configure: error:
      Collation utf8_hungarian_ci is not valid for character set utf8.
      Valid collations are: utf8_general_ci utf8_bin utf8_czech_ci utf8_danish_ci utf8_esperanto_ci utf8_estonian_ci utf8_icelandic_ci utf8_latvian_ci utf8_lithuanian_ci utf8_persian_ci utf8_polish_ci utf8_romanian_ci utf8_slovak_ci utf8_slovenian_ci utf8_spanish2_ci utf8_spanish_ci utf8_swedish_ci utf8_turkish_ci utf8_unicode_ci.
      See the Installation chapter in the Reference Manual.

Will there be any fix for this bug, please?

Hi Laszlo,
do you need "technical" collation with correct order for
single Hungarian letters, like this one:
http://www.collation-charts.org/oracle10g/ora10g.EE8MSWIN1250.HUNGARIAN.html

Or do you need "full" Hungarian collations with special multiple letters, like:
CS, GY, LY, NY, SZ, TY, ZS,
CCS, GGY, LLY, NNY, SSZ, ZZS, DDZS.
Like here:
http://www.collation-charts.org/oracle10g/ora10g.EE8MSWIN1250.XHUNGARIAN.html
?

Sorry for the previous message, I misread the report.

The problem is that "configure" doesn't accept --with-collation=utf8_hungarian_ci

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50491

2677 Alexander Barkov	2008-07-25
      Bug#35808 utf8 hungarian collation not part of the utf8 charset?
      config/ac-macros/character_sets.m4 didn't mention hungarian collations
      in the UTF8 and UCS2 lists.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50618

2680 Alexander Barkov	2008-07-29
      Bug#35808 utf8 hungarian collation not part of the utf8 charset?
      config/ac-macros/character_sets.m4 didn't mention hungarian collations
      in the UTF8 and UCS2 lists.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50620

2742 Alexander Barkov	2008-07-29 [merge]
      - Merging Bug#35808 "utf8 hungarian collation not part of the utf8 charset?"
      from 5.1.
      - Additional 6.0-specific changes made.

Pushed into mysql-5.1.28-bugteam
Pushed into mysql-6.0.7-bugteam

To me, it looks like this patch will make (at least) the "charset_collation_*" tests fail, because I expect adding these collations will cause different test output.

The developer is informed by mail.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51322

2765 Davi Arnaut	2008-08-11 [merge]
      Merge mysql-6.0-bugteam into mysql-6.0 main.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51420

2765 Davi Arnaut	2008-08-12 [merge]
      Merge mysql-6.0-bugteam into mysql-6.0 main.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51423

2765 Davi Arnaut	2008-08-12 [merge]
      Merge mysql-6.0-bugteam into mysql-6.0 main.

Pushed into 6.0.7-alpha  (revid:bar@mysql.com-20080729034207-bc41crgl5q8nfbq5) (version source revid:davi.arnaut@sun.com-20080812141852-8e6knbqclpfd8irn) (pib:3)

Pushed into 5.1.28  (revid:bar@mysql.com-20080729032546-6g0jbtodea8a57lg) (version source revid:davi.arnaut@sun.com-20080812142843-he05ncsggstbn57z) (pib:3)

Noted in 5.1.28, 6.0.7 changelogs.

The configure script did not allow utf8_hungarian_ci to be specified
as the default collation.

Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (version source revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (pib:3)

Pushed into 6.0.6-alpha  (revid:bar@mysql.com-20080729032546-6g0jbtodea8a57lg) (version source revid:hakan@mysql.com-20080716105246-eg0utbybp122n2w9) (pib:3)