To make a long story short, few years ago I was complaining that the sort order
of varchar, in UTF-8, was ignoring blanks, that is that the sort order was:
a
a
A
A
à
b
B
But, i was in need of a sort order that would place blanks BEFORE the other
char, that is I
On Sunday 20 January 2008 01:07, Tom Lane wrote:
Luca Arzeni [EMAIL PROTECTED] writes:
Is there any way to consider blanks meaningfull AND sort properly locale
specific vowels ?
This isn't a Postgres question, it's a locale question. (If you try,
you'll find that sort(1) sorts the same as
On Jan 15, 2008 6:37 PM, Tom Lane [EMAIL PROTECTED] wrote:
Luca Arzeni [EMAIL PROTECTED] writes:
That is: the sort order in postgres 8.1.9 seems to ignore the blank.
This is expected behavior in most non-C locales.
In all cases I'm using locale LATIN9 during DB creation, but I tested
On Jan 15, 2008 6:37 PM, Tom Lane [EMAIL PROTECTED] wrote:
Luca Arzeni [EMAIL PROTECTED] writes:
That is: the sort order in postgres 8.1.9 seems to ignore the blank.
This is expected behavior in most non-C locales.
Try initdb --locale=C.
Luca Arzeni [EMAIL PROTECTED] writes:
Is there any way to consider blanks meaningfull AND sort properly locale
specific vowels ?
This isn't a Postgres question, it's a locale question. (If you try,
you'll find that sort(1) sorts the same as we do in any given locale.)
I imagine you could
On Jan 15, 2008 6:37 PM, Tom Lane [EMAIL PROTECTED] wrote:
Luca Arzeni [EMAIL PROTECTED] writes:
That is: the sort order in postgres 8.1.9 seems to ignore the blank.
This is expected behavior in most non-C locales.
Try initdb --locale=C.
Hello,
you have to use correct localses for your encoding and country:
for czech and utf8 is
cs_CZ.UTF8 ..
for latin2 is
cs_CZ.latin2 etc
czech sorting has more exception and it works
caa
čaa
daa
cha ... it is well for czech
iaa
On 20/01/2008, Luca Arzeni [EMAIL PROTECTED] wrote:
On Jan
Hi there,
I have a table with a single column, pk of varchar type
The table contains few names, say:
A
C
B
In the first two records there is a between the and the following letter
A and C while, the third one has a B immediately following the (without
blanks).
In
On Tue, 2008-01-15 at 16:32 +0100, Luca Arzeni wrote:
In all cases I'm using locale LATIN9 during DB creation, but I tested also
with ASCII, UTF8 and LATIN1 encoding.
I guess this has nothing to do with the encoding, but with the collation
rules used, which is governed by lc_collate parameter.
Hi there,
I have a table with a single column, pk of varchar type
The table contains few names, say:
A
C
B
In the first two records there is a between the and the following letter
A and C while, the third one has a B immediately following the (without
blanks).
In
Luca Arzeni [EMAIL PROTECTED] writes:
That is: the sort order in postgres 8.1.9 seems to ignore the blank.
This is expected behavior in most non-C locales.
In all cases I'm using locale LATIN9 during DB creation, but I tested also
with ASCII, UTF8 and LATIN1 encoding.
LATIN9 isn't a locale,
11 matches
Mail list logo