Re: Collation rules and multi-lingual databases

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Dennis Gearon <gearond(at)fireserve(dot)net>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Collation rules and multi-lingual databases
Date: 2003-08-22 16:20:40
Message-ID: 878yplirzb.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Dennis Gearon <gearond(at)fireserve(dot)net> writes:

> I was thinking of INGNORING locale, since it is basically fixed for a DB for
> long periods of time.
>
> If a table/column HAD it's own locale, that could be used,
> but I was more interested in a function taht would allow the explicit
> declaration of the encoding(s) to look for.

Indeed for my purposes that's what I'll have to do.

but the strxfrm function uses the current application locale, so I'll have to
call setlocale to set it, call strxfrm, then call setlocale to set it back.

I fear that some implementations might do a lot of work when setlocale is
called loading large data files and might leak memory expecting it to only be
called once at program initialization. That would suck

> BTW, what is l10n

l10n = localization
i18n = internationalization

arguably i should have said i18n actually.

--
greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-08-22 16:21:50 Re: Buglist
Previous Message Manfred Koizar 2003-08-22 16:20:26 Re: [HACKERS] Buglist