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 amount of lines.. thanks, Yves A --- Jean-Marc PULVAR <[EMAIL PROTECTED]> wrote: > 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 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 > ----------------------------------------------------------- > ______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]