[GENERAL] Locale problem

2010-03-19 Thread S Arvind
Hello PG support, Recently i am facing locale problem in postgres 8.3. In my home machine i have 8.4 which have db schema as CREATE DATABASE impulse_travel WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'English_India.1252' LC_CTYPE = 'English_India.1252'

[GENERAL] Locale problem

2005-03-10 Thread go
Hi ! Im running PG 7.23 now with text fields in CP866. I tried to restore dump from 7.23 into PG 8.01 with following settings : - initdb --locale ru_RU - createdb -E ALT. all works great , but sort order in text fields is wrong People, help pls to megrate to PG 8.01 properly Thanks,

Re: [GENERAL] Locale problem

2005-03-10 Thread Miroslav ulc
go wrote: Hi ! Im running PG 7.23 now with text fields in CP866. I tried to restore dump from 7.23 into PG 8.01 with following settings : - initdb --locale ru_RU - createdb -E ALT. all works great , but sort order in text fields is wrong Both on Linux and Windows you should use for your