You can also use the query "SHOW VARIABLES LIKE 'character_set'" which will directly match what you want.
Yves wrote:
Hello,
How can I see what char set is being used as the default char set on the server or database?
Also, is there a way to change the default setting?
Thanks,
Yves
______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca
-- ----------------------------------------------------------- ___ _ __ / __\ ___ ___ _ __ | |_ _ _ (__) /__\/// _ \ / _ \| '_ \| __| | | | || / \/ \ (_) | (_) | | | | |_| |_| | || \_____/\___/ \___/|_| |_|\__|\__, | ___|""|__.._ |___/ /____________\ \____________/~~~ Jean-Marc PULVAR (Web Programmer) Boonty SA 4 bis villa du mont tonnerre 75015 PARIS -----------------------------------------------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]