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

> 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?

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

> > 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

Tatsuo Ishii writes:

> > > Add new configure option "--enable-uniconv" that enables automatic

Do you mind if we name this "--enable-unicode-conversion"?  It's a bit
longer, but that's why they're called long options. :)

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

> Do you mind if we name this "--enable-unicode-conversion"?  It's a bit
> longer, but that's why they're called long options. :)

Sounds reasonable:-) Please go ahead and change it.
--
Tatsuo Ishii