MySQL 4.0.x charset

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 --

Re: MySQL 4.0.x charset

You can see it by executing the SHOW VARIABLES query on your server. You will find the used charset in the 'character_set' variable. 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

Re: MySQL 4.0.x charset

Thanks, As it turns out, I was trying show variables like -- And had a syntax mistake Does SHOW VARIABLES only show a certain number of lines? When I ran this command, character_set was not listed... the list seemed cut off just before it. Unless it is an issue with SSH only showing x

Re: MySQL 4.0.x charset

It's possibly due to your ssh connection but I couldn't answer you about this because I only use mysql with phpmyadmin. Regards Yves wrote: Thanks, As it turns out, I was trying show variables like -- And had a syntax mistake Does SHOW VARIABLES only show a certain number of lines? When I