Finding which character set is used in a MySQL database / table / column? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Finding which character set is used in a MySQL database / table / column?

Damian99Damian99 USAPosts: 116Member

How can I check which character set is used in a MySQL database / table / column?

Tagged:

Comments

  • DavidMDavidM USAPosts: 342Member

    For table: SHOW CREATE TABLE databasename.tablename

    For database: SELECT DEFAULT_CHARACTER_SET_NAME FROM information_schema.SCHEMATA

Sign In or Register to comment.