MySQL Bugs: #6884: unknown collation latin1_spanish

Bug #6884	unknown collation latin1_spanish_ci by configure
Submitted:	29 Nov 2004 22:21	Modified:	6 Dec 2004 7:05
Reporter:	[ name withheld ]	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Compiling	Severity:	S3 (Non-critical)
Version:	4.1.7	OS:	Linux (linux debian)
Assigned to:	Alexander Barkov	CPU Architecture:	Any

Description:
When using "configure --with-charset=latin1 --with-collation=latin1_spanish_ci" reports "unknown collation".

How to repeat:
configure --with-charset=latin1 --with-collation=latin1_spanish_ci

Suggested fix:
Fix: edit configure and add latin1_spanish_ci in collation list for latin1

The configure error message shows only 7 collations for latin1
while "SHOW COLLATION" shows 8

Collation latin1_spanish_ci is not valid for character set latin1.
Valid collations are: 
latin1_general_ci 
latin1_general_cs 
latin1_bin 
latin1_german1_ci 
latin1_german2_ci 
latin1_danish_ci 
latin1_swedish_ci

mysql> show collation like "latin1_%";
+-------------------+---------+----+---------+----------+---------+
| Collation         | Charset | Id | Default | Compiled | Sortlen |
+-------------------+---------+----+---------+----------+---------+
| latin1_german1_ci | latin1  |  5 |         |          |       0 |
| latin1_swedish_ci | latin1  |  8 | Yes     | Yes      |       1 |
| latin1_danish_ci  | latin1  | 15 |         |          |       0 |
| latin1_german2_ci | latin1  | 31 |         | Yes      |       2 |
| latin1_bin        | latin1  | 47 |         | Yes      |       1 |
| latin1_general_ci | latin1  | 48 |         |          |       0 |
| latin1_general_cs | latin1  | 49 |         |          |       0 |
| latin1_spanish_ci | latin1  | 94 |         |          |       0 |
+-------------------+---------+----+---------+----------+---------+

First i thought this might be an off-by-one error but when trying
latin2 instead 

  configure --with-charset=latin2 --with-collation=latin1_spanish_ci

i got:

Collation latin1_spanish_ci is not valid for character set latin2.
Valid collations are: 
latin2_general_ci 
latin2_bin 
latin2_czech_cs 
latin2_hungarian_ci 
latin2_croatian_ci.

mysql> show collation like "latin2_%";
+---------------------+---------+----+---------+----------+---------+
| Collation           | Charset | Id | Default | Compiled | Sortlen |
+---------------------+---------+----+---------+----------+---------+
| latin2_general_ci   | latin2  |  9 | Yes     |          |       0 |
| latin2_hungarian_ci | latin2  | 21 |         |          |       0 |
| latin2_croatian_ci  | latin2  | 27 |         |          |       0 |
| latin2_bin          | latin2  | 77 |         |          |       0 |
+---------------------+---------+----+---------+----------+---------+
4 rows in set (0,00 sec)

mysql> show collation like "%czech%";
+---------------+---------+-----+---------+----------+---------+
| Collation     | Charset | Id  | Default | Compiled | Sortlen |
+---------------+---------+-----+---------+----------+---------+
| utf8_czech_ci | utf8    | 202 |         | Yes      |       8 |
+---------------+---------+-----+---------+----------+---------+
1 row in set (0,00 sec)

so this time configure reports a latin1_czech_cs collation that
does not exist within the server

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.8