Re: [GENERAL] setting the environment locale - linux, windows
On 4/21/06, Martijn van Oosterhout wrote: > On Fri, Apr 21, 2006 at 03:34:27PM +0200, Tomi NA wrote: > > On 4/21/06, Martijn van Oosterhout wrote: > > > You need to look at your LC_COLLATE settings. LC_COLLATE and LC_CTYPE > > > are fixed at initdb and constant across the DB. > > > > So, if I were to backup my database, clear the data directory, > > reinitialize the cluster and restore the database using the correct > > LC_COLLATE and LC_CTYPE, I'd have one language nailed? > > Well, you need the reinitialise the cluster with the correct language. > Once initiailised it doesn't matter what you restore with. > > > > > Are there plans to enable assigning locale at the database level? > > > > > > Plans, yes. Progress, a bit slow... > > > > No estimates, then? > > Nevertheless, thanks for the help. > > Well, I'm worked on COLLATE support which would get it down to the > column level. This is pretty much what you need, since indexes could be > shared between databases and each database needs the same definition > for those indexes. > > I'm got a fair way but got a little over my head, so unless someone > picks it up and completes it, it could be a while... I'd be more than happy to lend a hand if I had a 9 to 5 job...*if* I had a 9 to 5 job. A man can dream... :-\ t.n.a. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] setting the environment locale - linux, windows
On Fri, Apr 21, 2006 at 03:34:27PM +0200, Tomi NA wrote: > On 4/21/06, Martijn van Oosterhout wrote: > > You need to look at your LC_COLLATE settings. LC_COLLATE and LC_CTYPE > > are fixed at initdb and constant across the DB. > > So, if I were to backup my database, clear the data directory, > reinitialize the cluster and restore the database using the correct > LC_COLLATE and LC_CTYPE, I'd have one language nailed? Well, you need the reinitialise the cluster with the correct language. Once initiailised it doesn't matter what you restore with. > > > Are there plans to enable assigning locale at the database level? > > > > Plans, yes. Progress, a bit slow... > > No estimates, then? > Nevertheless, thanks for the help. Well, I'm worked on COLLATE support which would get it down to the column level. This is pretty much what you need, since indexes could be shared between databases and each database needs the same definition for those indexes. I'm got a fair way but got a little over my head, so unless someone picks it up and completes it, it could be a while... Have a nice day, -- Martijn van Oosterhout http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate. signature.asc Description: Digital signature
Re: [GENERAL] setting the environment locale - linux, windows
On 4/21/06, Martijn van Oosterhout wrote: > On Fri, Apr 21, 2006 at 12:49:31AM +0200, Tomi NA wrote: > > This is probably somewhat offtopic, but it does relate to postgresql so... > > Problem summary: I have a UTF-8 encoded database running on linux on > > which upper() and lower() string functions ignore locale specific > > characters. > > You need to look at your LC_COLLATE settings. LC_COLLATE and LC_CTYPE > are fixed at initdb and constant across the DB. So, if I were to backup my database, clear the data directory, reinitialize the cluster and restore the database using the correct LC_COLLATE and LC_CTYPE, I'd have one language nailed? > > Are there plans to enable assigning locale at the database level? > > Plans, yes. Progress, a bit slow... No estimates, then? Nevertheless, thanks for the help. Tomislav ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] setting the environment locale - linux, windows
On Fri, Apr 21, 2006 at 12:49:31AM +0200, Tomi NA wrote: > This is probably somewhat offtopic, but it does relate to postgresql so... > Problem summary: I have a UTF-8 encoded database running on linux on > which upper() and lower() string functions ignore locale specific > characters. You need to look at your LC_COLLATE settings. LC_COLLATE and LC_CTYPE are fixed at initdb and constant across the DB. > Are there plans to enable assigning locale at the database level? Plans, yes. Progress, a bit slow... Have a nice day, -- Martijn van Oosterhout http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate. signature.asc Description: Digital signature
