469,923 Members | 1,785 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,923 developers. It's quick & easy.

SHOW CHARACTER SET syntax

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!
Jul 19 '05 #1
0 3309

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Thiko | last post: by
4 posts views Thread by John Winterbottom | last post: by
15 posts views Thread by pkaeowic | last post: by
14 posts views Thread by Shhnwz.a | last post: by
2 posts views Thread by Sudhakar | last post: by
13 posts views Thread by Ivan | last post: by
7 posts views Thread by Keith Thompson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.