Re: Significance of Database Encoding [ update ]

I am not sure why the characters did not display properly
in the mailling list archives.

http://archives.postgresql.org/pgsql-sql/2005-05/msg00102.php

but when i do the select in my screen (xterm -u8) i do
see the japanese glyphs properly.

Regds
Mallah.

--- Rajesh Mallah <mallah_rajesh(at)yahoo(dot)com> wrote:
> 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 |
> +--------------------------------------------------------------------------------------+
> | &#31169;&#12399;&#12460;&#12521;&#12473;
>
> |
> +--------------------------------------------------------------------------------------+
>
> 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
>

Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out!
http://discover.yahoo.com/weekend.html