MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Listing database, table and field character set and collation
Posted by: Andrew Dixon
Date: August 05, 2008 10:05AM

Hi,

Is it possible to get the character set and collation for a database, tables and fields using queries. I have taken a look at the 'show' operator and 'describe' but I don't seem to be able to find them.

I would like to get a list of all the databases using 'show databases' then loop over this list of databases and get the tables in each database using 'show tables' and then over this list to get each table fields and from this produce a list of the character set and collation of each.

Can anyone help?

Kind regards,

Andrew.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Listing database, table and field character set and collation
5512
Andrew Dixon
August 05, 2008 10:05AM
Re: Listing database, table and field character set and collation
2617
Susan Ottwell
August 26, 2008 07:46AM
Re: Listing database, table and field character set and collation
3028
Peter Gulutzan
August 26, 2008 03:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.