Home  »     »  How to check character set of a mysql table?

How to check character set of a mysql table?

Monday, December 9, 2013



You can check the character set of Db, tables, columns by using following


 SHOW FULL COLUMNS FROM `TABLE_NAME`

check the Collation column value corresponding to field name

-------------

SHOW TABLE STATUS
will list all the tables, and the collation column contains details about the character set that each table uses

---------------

USE DatabaseName;

and enter,

show variables like "character_set_database";
show variables like "collation_database";



How to link to this page?
If you wish to link to this page from your website, simply Copy and paste the above HTML code to your web page. It will appear on your page as:
How to check character set of a mysql table?.




Share this!




comments powered by Disqus

This Weeks 7 Popular Posts


Subscribe to Recent Posts by Email
Stay connected to CROZOOM with regular Email notices of new Techie articles and IT Jobs. Updates will be delivered to your Inbox as soon as they are posted online.

Enter Your Email Address:  

Delivered by FeedBurner   RSS Feed

Search this Blog   



Urgent Openings for PHP trainees, Andriod / IOS developers and PHP developers in Kochi Trivandrum Calicut and Bangalore. Please Send Your updated resumes to recruit.vo@gmail.com   Read more »