Bug #21584 Collation (dataset) not in ISO format + french keyset

• Submitted: 11 Aug 2006 14:11
• Modified: 14 Aug 2006 17:02
• Reporter: Sebastien MALTRET - UzData
• Status: Won't fix
• Category: MySQL Workbench Preview
• Severity: S4 (Feature request)
• Version: 1.0.6.beta
• OS: Any (ALL)
• CPU Architecture: Any

[11 Aug 2006 14:11] Sebastien MALTRET - UzData

Description:
When creating a table, the choice of "collation" (language specific keyset) is not in iso format.
That would be much better to be able to choose ISO-8859-15, instead of (latin1_xxx).
Specific French keyset have been forgotten! Thanks (merci) to update the list.

How to repeat:
Create a table

Suggested fix:
1. Offer the list of keyset in iso format
2. Add french keyset

[14 Aug 2006 17:02] MySQL Verification Team

Thank you for the bug report. I am changing to feature request since that
is the current behavior:

c:\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 5.0.24-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show collation;
+----------------------+----------+-----+---------+----------+---------+
| Collation            | Charset  | Id  | Default | Compiled | Sortlen |
+----------------------+----------+-----+---------+----------+---------+
| big5_chinese_ci      | big5     |   1 | Yes     | Yes      |       1 |
| big5_bin             | big5     |  84 |         | Yes      |       1 |
| dec8_swedish_ci      | dec8     |   3 | Yes     |          |       0 |
| dec8_bin             | dec8     |  69 |         |          |       0 |
| cp850_general_ci     | cp850    |   4 | Yes     |          |       0 |
| cp850_bin            | cp850    |  80 |         |          |       0 |