domingo, 26 de julio de 2015

How to find out the charset of a database and table with PHPmyAdmin

Is there a way in PHPMyAdmin to find out the charset of a table and/or a database?
The only thing that ist shown, is the collation. But as far as I understood, the collation only tells the database how to compare the data, and the charset tells the database how to store the data.
RESPUESTA
SELECT * FROM information_schema.SCHEMATA S
WHERE schema_name = "myDataBase";

No hay comentarios:

Publicar un comentario