Canot make Index Descending ?

[Gary]

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

[Joe Smith]

Gary wrote:

Whatever I try I do not seem to be able to get the keys to be Descending.

What does that have to do with Perl?

If you have an SQL problem, go post it to an SQL newsgroup.
If you have a Perl problem, go post it to comp.lang.perl.misc instead of here.
-Joe

[Gary]

"Joe Smith" <Jo*******@inwap.com> wrote in message
news:q0I7c.59576$JL2.765032@attbi_s03...

Gary wrote:

Whatever I try I do not seem to be able to get the keys to be

Descending.
What does that have to do with Perl?

If you have an SQL problem, go post it to an SQL newsgroup.
If you have a Perl problem, go post it to comp.lang.perl.misc instead of here. -Joe

Good point

Thanks.