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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
