On Mon, Jan 22, 2001 at 03:09:03PM -0800, Nathan Myers wrote:
...
> Posix systems include a set of commands for dumping locales in a standard
> format, and building from them. Instead of shipping locales and code to
> operate on them, one might include a script to run these tools (where
> the
On Mon, Jan 22, 2001 at 05:46:09PM -0500, Tom Lane wrote:
...
> Are there any BSD-license locale and/or timezone libraries that we might
> assimilate in this way? We could use an LGPL'd library if there is no
> other alternative, but I'd just as soon not open up the license issue.
The "Citrus P
> And IIRC SQL9x prescribe support for multiple locales (or at least
> multiple
> collating sequences) within one database simultaneously.
Sounds like SQL92/99 COLLATE things is the way we should go, IMHO.
--
Tatsuo Ishii
On Mon, Jan 22, 2001 at 05:46:09PM -0500, Tom Lane wrote:
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > Is there any possibility to use, in a portable way, only our own locale
> > definition files, without reimplementing all the sorts uppercases etc. ?
>
> The situation is not too much differe
Hannu Krosing <[EMAIL PROTECTED]> writes:
> Is there any possibility to use, in a portable way, only our own locale
> definition files, without reimplementing all the sorts uppercases etc. ?
AFAIK there is not --- the standard C library APIs do not specify how to
represent this information. Thu
Peter Eisentraut wrote:
>
> Tom Lane writes:
>
> > Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
> > > Just to understand things correctly. Is the Like optimization disabled
> > > for all non-ASCII char sets, or (imho correctly) for non charset ordered
> > > collations (LC_COLLATE) ?
> >
>
Tom Lane writes:
> Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
> > Just to understand things correctly. Is the Like optimization disabled
> > for all non-ASCII char sets, or (imho correctly) for non charset ordered
> > collations (LC_COLLATE) ?
>
> Currently it's disabled whenever LC_COLL
Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
> Just to understand things correctly. Is the Like optimization disabled
> for all non-ASCII char sets, or (imho correctly) for non charset ordered
> collations (LC_COLLATE) ?
Currently it's disabled whenever LC_COLLATE is neither C nor POSIX.
> > I made a reproduceable example of things going wrong with a "en_US"
> > locale which is the widely-used (single-byte) ISO-8859-1 Latin 1 charset.
>
> en_US uses multi-pass collation rules. It's those collation rules, not
> the charset per se, that causes the problem.
Just to understand thi
