[GENERAL] Locale problem
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' CONNECTION LIMIT = -1; But in production server we are limited to postgres 8.3 only. So while creating db i cant able to provide LC_COLLATE , LC_CTYPE . So i did initdb initdb -W --locale=en_IN --lc-collate=en_IN --lc-ctype=en_IN --lc-messages=en_IN --lc-monetary=en_IN --lc-numeric=en_IN --lc-time=en_IN -D /var/lib/pgsql/data4 but even then it seems it doesnt set. I used test query as select 'Rs.6,000.00'::money; this returns value in home pgsql 8.4 server but in the production server it throws error as template1=# select 'Rs.6,000.00'::money; ERROR: invalid input syntax for type money: Rs.6,000.00 I want to know whether it is possible in postgres 8.3 and if yes where i went wrong? Thanks in advance, Arvind S Many of lifes failure are people who did not realize how close they were to success when they gave up. -Thomas Edison
[GENERAL] Locale problem
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, and have a nice day!! Igor ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Locale problem
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 databases the same encoding as your system supports. On Linux you can see your locales using 'locale -a'. On my Linux I have these ru_RU.*: ru_RU ru_RU.iso88595 ru_RU.koi8r ru_RU.utf8 I would try 'initdb --locale ru_RU.utf8' (or any other with specified encoding) and set the same encoding for the database (= in this example 'UNICODE'). Then the sorting should be correct. I'm just a newbie for PostgreSQL so somebody might explain it more precisely. People, help pls to megrate to PG 8.01 properly Thanks, and have a nice day!! Igor Miroslav ulc begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika email;internet:[EMAIL PROTECTED] title:CEO tel;work:+420 257 225 602 tel;cell:+420 603 711 413 x-mozilla-html:TRUE url:http://www.startnet.cz version:2.1 end:vcard ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]