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 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
--
-----------------------------------------------------------
___ _
__ / __\ ___ ___ _ __ | |_ _ _
(__) /__\/// _ \ / _ \| '_ \| __| | | |
|| / \/ \ (_) | (_) | | | | |_| |_| |
|| \_____/\___/ \___/|_| |_|\__|\__, |
___|""|__.._ |___/
/____________\
\____________/~~~ 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]