Re: [HACKERS] Implications of multi-byte support in a distribution

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: t-ishii(at)sra(dot)co(dot)jp, Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, hackers(at)postgresql(dot)org, 43702(at)bugs(dot)debian(dot)org
Subject: Re: [HACKERS] Implications of multi-byte support in a distribution
Date: 1999-09-01 05:48:59
Message-ID: Pine.GSO.3.96.SK.990901094016.6807N-100000@ra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 1 Sep 1999, Thomas Lockhart wrote:

> Date: Wed, 01 Sep 1999 02:55:48 +0000
> From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
> To: t-ishii(at)sra(dot)co(dot)jp
> Cc: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Oliver Elphick <olly(at)lfix(dot)co(dot)uk>,
> hackers(at)postgresql(dot)org, 43702(at)bugs(dot)debian(dot)org
> Subject: Re: [HACKERS] Implications of multi-byte support in a distribution
>
> > That shouldn't be too difficult, if we have an encoding infomation
> > with each text column or literal. Maybe now is the time to introuce
> > NCHAR?

Yes, postgres after 6.5 and especially recent win becomes very popular
and additional performance hit would be very in time. Does implementing
of NCHAR only could solve all problem with text, varchar etc ?

>
> I've been waiting for a go-ahead from folks who would use it. imho the
> way to do it is to use Postgres' type system to implement it, rather
> than, for example, encoding "type" information into each string. We
> can also define a "default encoding" for each database as a new column
> in pg_database...

go-ahead, Tom :-) I would use it.

>
> > BTW, it is interesting that people does not hesitate to enable
> > with-locale option even if they only use ASCII. I guess the
> > performance degration by enabling locale is not too small.
>
> Red Hat built their RPMs with locale enabled, and there is a
> significant performance hit. Implementing NCHAR would be a better
> solution, since the user can choose whether to use SQL_TEXT or the
> locale-specific character set at run time...
>
> - Thomas
>
> --
> Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
> South Pasadena, California
>
> ************
>

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 1999-09-01 06:09:19 Changes for 6.5.2 ?
Previous Message Thomas Lockhart 1999-09-01 02:55:48 Re: [HACKERS] Implications of multi-byte support in a distribution