Hi
According to the official mysql manual:
http://www.mysql.com/doc/en/Charset-SHOW-CHARSET.html
The syntax to show all available character sets is the SHOW CHARACTER
SET command. It takes an optional LIKE clause that indicates which
character set names to match.
I have tried various commbinations and continually get an error about
the syntax being incorrect.
mysql> SHOW CHARACTER SET LIKE '%';
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'CHARACTER SET LIKE '%'' at line 1
mysql> show character set;
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'character set' at line 1
I am running version: 4.0.15 of MySQL.
Does anyone have any ideas? Does this mean i have no character sets
installed other than the default? I see no /charsets directory on the
linux machine itself.
Many thanks.
Thiko!