Hi,

I'm using MySQL 5.0. How do I check what collation a table is using?
The command "DESC my_table" doesn't produce the desired output.

Thanks, - Dave

On Wed, 14 Nov 2007 18:45:35 +0100, laredotornado@zipmail.com
<laredotornado@zipmail.com> wrote:

> Hi,
>
> I'm using MySQL 5.0. How do I check what collation a table is using?
> The command "DESC my_table" doesn't produce the desired output.
>
> Thanks, - Dave

SHOW TABLE STATUS;

(optionally followed by "LIKE 'my_table'")
--
Rik Wasmus