> Unicode is not currently supported when the server runs on Win32, see
> http://www.postgresql.org/docs/faqs.FAQ_windows.html#2.6. You'll need to
> pick a different encoding if you need locale-aware sorting.
I need to upsize tables from other dbms. This dbms does not support unicode.
I have tabl
> I insalled Postgres 8 in Windows XP with default settings I
> xreated database with encoding unicode.
Unicode is not currently supported when the server runs on Win32, see
http://www.postgresql.org/docs/faqs.FAQ_windows.html#2.6. You'll need to
pick a different encoding if you need locale-aware
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Andrus <[EMAIL PROTECTED]> wrote:
>> SHOW ALL command returns the following:
>>
>> "client_encoding";"UNICODE"
>> "lc_collate";"Estonian_Estonia.1257"
>> "lc_ctype";"Estonian_Estonia.1257"
>> "lc_messages";"Estonian_Estonia.1257"
>> "lc_monetary";"Es
On Tue, Jul 12, 2005 at 22:09:40 +0300,
Andrus <[EMAIL PROTECTED]> wrote:
> > Sort order depends on the locale used in initdb. If you want data sorted
> > by the codes used to represent the data, then you might want to initdb
> > with a locale of "C". Doing an initdb will require a dump and reloa
> Sort order depends on the locale used in initdb. If you want data sorted
> by the codes used to represent the data, then you might want to initdb
> with a locale of "C". Doing an initdb will require a dump and reload.
Bruno, thank you.
SHOW ALL command returns the following:
"client_encoding";
On Tue, Jul 12, 2005 at 20:45:37 +0300,
Andrus <[EMAIL PROTECTED]> wrote:
>
> How to force the correct sort order or at least move accented characters
> ÕÄÖÜ to end of sorted list ?
Sort order depends on the locale used in initdb. If you want data sorted
by the codes used to represent the data,
I insalled Postgres 8 in Windows XP with default settings
I xreated database with encoding unicode.
I noticed that the sort order of accented characters is
B
Ü
Ö
C.
Ä
Õ
C
this is totally incorrect! It is interesting that names beginning with C
are not contiguous: between C. and C are accented c
