Re: Unicode conversion (Re: [COMMITTERS] pgsql (configure.in))

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: peter_e(at)gmx(dot)net
Cc: ishii(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Unicode conversion (Re: [COMMITTERS] pgsql (configure.in))
Date: 2000-10-31 00:40:32
Message-ID: 20001031094032N.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

> > Add new configure option "--enable-uniconv" that enables automatic
> > code conversion between Unicode and other encodings. Note that
> > this option requires --enable-multibyte also.
> > The reason why this is optional is that the feature requires huge
> > mapping tables and I don't think every user need the feature.
>
> Can you explain what this does? Does it mean frontends can use Unicode as
> their character set?

Yes. Here are some examples:

(1) both backend/frontend uses Unicode(actually UTF-8)

$ createdb -E unicode unicode
$ psql unicode
[some sessions follow using UTF-8]
:
:

Note that this is not a new functionality as opposite to (2), (3).

(2) backend is ISO8859-2 but frontend is UNICODE

$ createdb -E LATIN2 latin2
$ psql latin2
\encoding UNICODE
[some sessions follows using UTF-8]
:
:

Note that if you type in a wrong ISO8859-2 character that could not be
converted to UTF-8, you would get notices something like:

NOTICE: local_to_utf: could not convert (0x00b4) LATIN2 to UTF-8. Ignored

(3) backend is Unicode but frontend is ISO8859-2

$ createdb -E unicode unicode
$ psql unicode
\encoding LATIN2
[some sessions follow using ISO8859-2]
:
:

Same note above...
--
Tatsuo Ishii

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message petere 2000-10-31 10:22:10 pgsql/src/backend/nodes (copyfuncs.c equalfuncs.c list.c outfuncs.c read.c)
Previous Message petere 2000-10-30 17:54:17 pgsql/src/backend/parser (scan.l)

Browse pgsql-hackers by date

  From Date Subject
Next Message Arnold Gamboa 2000-10-31 05:25:04 how good is PostgreSQL
Previous Message Peter Mount 2000-10-30 19:10:37 Re: Current CVS broken?