How can I find out the charsets supported by my DB?

[cadbilbao]

Hello.

I want to find out the charsets supported by DataBase.
I tried "SHOW CHARACTER SET" but I get this error:

---------------
mysql> SHOW CHARACTER SET;
ERROR 1064: You have an error in your SQL syntax near 'CHARACTER SET' at line 1
------------------

Is there any different way to find it out? How can I
add another charset?

Thank you very much. Regards.

 

[tshot]

long time ur post was unreplied. by the way have u checked the \s output in mysql. it shows

mysql> \s
--------------
mysql  Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)

Connection id:          3
Current database:       BBK
Current user:           amit@[URL unfurl="true"]www.tshot.com[/URL]
Current pager:          stdout
Using outfile:          ''
Server version:         3.23.41-log
Protocol version:       10
Connection:             [URL unfurl="true"]www.tshot.com[/URL] via TCP/IP

Client characterset: latin1
Server characterset: latin1

TCP port:               3306
Uptime:                 1 hour 18 min 8 sec

Threads: 1  Questions: 7  Slow queries: 0  Opens: 7  Flush tables: 1  Open tables: 1 Queries per second avg: 0.001
--------------

the colour and line space just for highlighting the output
and also with mysqladmin

 mysqladmin -u root variables | grep char
| character_set                   | latin1

                                            |
| character_sets                  | latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7
win1250 win1251 win1251ukr ujis sjis tis620 |

These | just y\the line separators
also see

http://www.mysql.com/doc/en/Charset-connection.html

----------------
ur feedback is a very welcome desire