Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-29 Thread Vincent . Gaboriau
Tom Lane a écrit : > [EMAIL PROTECTED] writes: > > Ok! And does the new version correct my character sequences error? > > Which was ...? Refer to " [ADMIN] character sequence problem" Thanks for your help. regards, Vincent. ---(end of broadcast)-

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-29 Thread Vincent . Gaboriau
Tom Lane a écrit : > [EMAIL PROTECTED] writes: > >> Er ... *what* version did you say you were running? That doesn't look > >> like a 7.1 pg_control to me. > > > No, I have an 7.0.2 on Linux Mandrake 7.2. > > Time to update then. 7.0 doesn't freeze the LC_COLLATE setting at > initdb, which me

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-28 Thread Vincent . Gaboriau
Tom Lane a écrit : > [EMAIL PROTECTED] writes: > > But I have This in my pg_control file: > > > # od -c pg_control > > 000 \0 \0 \0 \0 001 \0 \0 \0 \0 \0 \0 \0 \b \0 \0 \0 > > 020 ¤ 006 004 < 004 \0 \0 \0 \0 \0 \0 \0 \0 002 \0 > > 040 ± Õ ë \v

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-28 Thread Vincent . Gaboriau
Tom Lane a écrit : > [EMAIL PROTECTED] writes: > >> You might be able to get it by looking through the > >> /global/pg_control file, but it's a binary file so you'll have > >> to search for it. > > > I had found it, but I don't know speak fluent binary language ;-) > > Does a way exist to "dec

[ADMIN] éèàïîù Problem

2001-11-28 Thread Vincent . Gaboriau
Hi all, I had curious problem with the characters like " éèàïîù... " (refer to my first mail "[ADMIN] character sequence problem" for more information). My database was encoding with UNICODE. I have created another one with LATIN1 encoding, and I have'nt anymore those problems! Can any one explai

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-28 Thread Vincent . Gaboriau
> > The sources of postgres have been deleted, so I can't find this "contrib"! > > So I surch another way to know if postgres have been installed with the local > > configuration. > > Can anyone help me? > > You might be able to get it by looking through the > /global/pg_control file, but it's a b

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-27 Thread Vincent . Gaboriau
Stephan Szabo a écrit : > On Tue, 27 Nov 2001 [EMAIL PROTECTED] wrote: > > > > > Tom Lane a écrit : > > > > > =?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?= <[EMAIL PROTECTED]> writes: > > > > uppercase umlauts are not converted. > > > > > > Did you run initdb with the correct LANG environment? > > >

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german umlaut?

2001-11-27 Thread Vincent . Gaboriau
Tom Lane a écrit : > =?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?= <[EMAIL PROTECTED]> writes: > > uppercase umlauts are not converted. > > Did you run initdb with the correct LANG environment? > > To check, run contrib/pg_controldata and see what it says about > LC_COLLATE and LC_CTYPE. I have relat

[ADMIN] character sequence problem

2001-11-23 Thread Vincent . Gaboriau
Hi all, A cursious problem occurs with some character sequences with french characters. I have seen lots of things on the internet to solve this foreign charater problem but nothing works! I have PostgreSQL v 7.0.2 under Linux. I give you some expemple under psql ("intradev" is the database name