Canot make Index Descending ?

From: Gary (reachus_at_netlink.info)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 11:17:39 -0500

Whatever I try I do not seem to be able to get the keys to be Descending. I
assume collation A means Ascending which indeed they are when I enter DATA ?

I use

CREATE TABLE WGSubCategory (
  CATId decimal(3,0) default 0,
  SUCId decimal(3,0) default 0,
  SUCDescription char(30) default NULL,
  CATActive decimal(1,0) default 1,
  UNIQUE KEY WGSubCategoryI (CATId DESC, SUCId DESC)
) TYPE=MyISAM;

mysql> show index from WGSubCategory;
+---------------+------------+----------------+--------------+-------------+
-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+---------------+------------+----------------+--------------+-------------+
-----------+-------------+----------+--------+------+------------+---------+
| WGSubCategory | 0 | WGSubCategoryI | 1 | CATId |
A | NULL | NULL | NULL | YES | BTREE | |
| WGSubCategory | 0 | WGSubCategoryI | 2 | SUCId |
A | NULL | NULL | NULL | YES | BTREE | |
+---------------+------------+----------------+--------------+-------------+
-----------+-------------+----------+--------+------+------------+---------+

Collation is A regardless of DESC in the index table creation

Help please.

Gary