niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » PostgreSQL
Locale problem
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
Miroslav Šulc
*nix forums beginner


Joined: 05 Mar 2005
Posts: 9

PostPosted: Thu Mar 10, 2005 11:40 am    Post subject: Re: Locale problem Reply with quote
go wrote:

Quote:
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.

Quote:
People, help pls to megrate to PG 8.01 properly

Thanks, and have a nice day!!

Igor


Miroslav Šulc
Back to top
go
*nix forums beginner


Joined: 10 Mar 2005
Posts: 14

PostPosted: Thu Mar 10, 2005 9:03 am    Post subject: Locale problem Reply with quote
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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Thu Jan 08, 2009 7:58 am | All times are GMT
navigation Forum index » Databases » PostgreSQL
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Unknown in header problem -SOLVED- Light Speed Postfix 0 Thu Jul 03, 2008 10:40 am
No new posts problem with sending mail nuxia Postfix 0 Mon Apr 21, 2008 3:58 am
No new posts Postfix 2.3.8 Virtual problem Blotto Postfix 0 Fri Apr 04, 2008 6:11 am
No new posts Postfix sending problem for local domain remote email monkey_magix Postfix 0 Mon Sep 10, 2007 10:17 am
No new posts bounce problem murkis Postfix 0 Sun Oct 08, 2006 3:45 pm

Loan | Blog5 Game Cheats | Credit Card | Live mortgage rates | Xbox Mod Chips
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.4183s ][ Queries: 20 (0.3410s) ][ GZIP on - Debug on ]