On Sun, 2008-06-01 at 22:13 -0700, David E. Wheeler wrote:
> What locale is right? If I have a Web app, there could be data in many
> different languages in a single table/column.
I think the values should be explicitly treated differently.
It would be nice if you could just typecast, like:
which would then lowercase according to the fr_CA locale, regardless of
the locale of "somevalue".
Using typmod for localization was brought up here:
Has it been discussed further? I happen to like the idea of the TEXT
type taking a locale as a typmod. No typmod would, of course, fall back
to the cluster setting. And it would throw an exception if the encoding
couldn't represent that locale.
In response to
pgsql-hackers by date
|Next:||From: Josh Berkus||Date: 2008-06-02 18:06:04|
|Subject: Re: Overhauling GUCS|
|Previous:||From: Martijn van Oosterhout||Date: 2008-06-02 17:55:16|
|Subject: Re: Case-Insensitve Text Comparison|