SQL_ASCII and UNICODE server_encoding

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL_ASCII and UNICODE server_encoding
Date: 2004-08-16 13:56:29
Message-ID: Pine.LNX.4.44.0408161640340.29016-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi,
i'd like to ask if there is any difference in server_encoding
SQL_ASCII and UNICODE (there must be
one since the different terms), but
AFAIU
-databases which store in SQL_ASCII (i.e. server_encoding=SQL_ASCII)
have no problem storing 8bit chars with the first bit set.
-databases with server_encoding=UNICODE actually store in UTF-8 encoding
-The purpose of UTF-8 is to make possible that multibyte chars can
be stored in systems that represent chars in 8 bits
-So SQL_ASCII is fine for UTF-8, hence multibyte UNICODE.

So if SQL_ASCII should be fine for UTF-8 storage.
(here i must have missed something, tho..), whats
the purpose of server_encoding=UNICODE?
--
-Achilleus

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-08-16 14:28:42 Re: Inheriting text[] field
Previous Message George Weaver 2004-08-16 12:40:04 Re: Returning A Varchar From A Function