Significance of Database Encoding

Hi ,

I would want to know what is the difference between databases
that are created using UNICODE encoding and SQL_ASCII encoding.

I have an existing database that has SQL_ASCII encoding but
still i am able to store multibyte characters that are not
in ASCII character set. for example:

tradein_clients=# \l

List of databases
+-----------------+----------+-----------+
| Name | Owner | Encoding |
+-----------------+----------+-----------+
| template0 | postgres | SQL_ASCII |
| template1 | postgres | SQL_ASCII |
| tradein_clients | tradein | SQL_ASCII |
+-----------------+----------+-----------+

tradein_clients=# SELECT * from t_A;
+--------------------------------------------------------------------------------------+
| a |
+--------------------------------------------------------------------------------------+
| 私はガラス
|
+--------------------------------------------------------------------------------------+

Above is some japanese character.

I have seen some posting regarding migrating databases from
SQL_ASCII to UNICODE, given the above observation what
significance does a migration have.

Regards

Rajesh Kumar Mallah.

__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail