Character set of table or column

[Christian Trummer]

hello

i try to read the character set and collation from each table in an database. to read the collation of a database i use

select @@character_set_database

but how do i get the character set of an table in this database?? i can't find anything in the documentation

http://www.get-the-answer.info - Ask Questions, Get Answers
http://www.finanztalk.info - German finance/stock board