Re: [HACKERS] confused with encodings

2003-06-17 Thread Peter Eisentraut
Oleg Bartunov writes: > I thought I could specify different encodings for different databases > and these encodings will be used in text operations (sort, upper,lower), > not just for conversion. But, actually, the only encoding is important > for text operations - the one specified with 'initdb'

Re: [HACKERS] confused with encodings

2003-06-17 Thread Oleg Bartunov
On Tue, 17 Jun 2003, Tatsuo Ishii wrote: > > > [I assume you enable the locale support.] > > > > isn't it enabled by default ? > > It can be off by using ---no-locale option with initdb. > what's the benefit of this for non-ascii world :? > > > Dont't ask me. These are locale support problems. >

Re: [HACKERS] confused with encodings

2003-06-17 Thread Tatsuo Ishii
> > [I assume you enable the locale support.] > > isn't it enabled by default ? It can be off by using ---no-locale option with initdb. > > Dont't ask me. These are locale support problems. > > Sorry, I just wanted to understand where I get confused. > You're right, utf8 locale support in glibc

Re: [HACKERS] confused with encodings

2003-06-17 Thread Oleg Bartunov
On Tue, 17 Jun 2003, Tatsuo Ishii wrote: > > Tatsuo, > > > > recently I tried to understand why I can't get sorting works properly > > with cyrillic characters in UTF8 datbase. I figure out the > > reason of my confusion - I thought I could specify different encodings > > for different databases

Re: [HACKERS] confused with encodings

2003-06-16 Thread Dennis Björklund
On Mon, 16 Jun 2003, Oleg Bartunov wrote: > I thought I could specify different encodings > for different databases and these encodings will be used in text operations > (sort, upper,lower), not just for conversion. En encoding does not imply any sort order. UTF-8 can be used to store strings in

Re: [HACKERS] confused with encodings

2003-06-16 Thread Tatsuo Ishii
> Tatsuo, > > recently I tried to understand why I can't get sorting works properly > with cyrillic characters in UTF8 datbase. I figure out the > reason of my confusion - I thought I could specify different encodings > for different databases and these encodings will be used in text operations >

[HACKERS] confused with encodings

2003-06-16 Thread Oleg Bartunov
Tatsuo, recently I tried to understand why I can't get sorting works properly with cyrillic characters in UTF8 datbase. I figure out the reason of my confusion - I thought I could specify different encodings for different databases and these encodings will be used in text operations (sort, upper,