469,126 Members | 1,281 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

query for viewing column's character set

304 100+
hi,
I would like to know the query for viewing the character set type of a table's column.
thanks,
gomzi.
Apr 14 '07 #1
2 1257
masdi2t
37
hi,
I would like to know the query for viewing the character set type of a table's column.
thanks,
gomzi.

how about SHOW CREATE TABLE command
Apr 19 '07 #2
Expand|Select|Wrap|Line Numbers
  1. SHOW FULL COLUMNS FROM t;
Result:
+-------+---------+------------+------+-----+---------+-------+
| Field | Type | Collation | Null | Key | Default | Extra |
+-------+---------+------------+------+-----+---------+-------+
| a | char(1) | latin1_bin | YES | | NULL | |
| b | int(11) | NULL | YES | | NULL | |
+-------+---------+------------+------+-----+---------+-------+

More info on this subject:
http://www.browardphp.com/mysql_manu...l_Charset.html
Apr 19 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Mike Leahy | last post: by
6 posts views Thread by Rory Campbell-Lange | last post: by
5 posts views Thread by kaustubh.deo | last post: by
9 posts views Thread by Sinner | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.