X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DF184D1B1B3 for ; Wed, 19 May 2004 14:31:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 19643-08 for ; Wed, 19 May 2004 14:31:07 -0300 (ADT) Received: from barok.foi.hr (barok.foi.hr [161.53.120.3]) by svr1.postgresql.org (Postfix) with ESMTP id C8C5FD1CA44 for ; Wed, 19 May 2004 14:30:25 -0300 (ADT) Received: from barok.foi.hr (krabuzin@localhost [127.0.0.1]) by barok.foi.hr (8.12.10/8.12.10) with ESMTP id i4JHUMUv016990; Wed, 19 May 2004 19:30:22 +0200 (MEST) Received: from localhost (krabuzin@localhost) by barok.foi.hr (8.12.10/8.12.2/Submit) with ESMTP id i4JHUInC016986; Wed, 19 May 2004 19:30:20 +0200 (MEST) Date: Wed, 19 May 2004 19:30:18 +0200 (MEST) From: Kornelije Rabuzin To: =?ISO-8859-1?Q?Beno=EEt_BOURNON?= Cc: pgsql-sql@postgresql.org Subject: Re: Replace function ... In-Reply-To: <40AB35D3.2070602@adelis.com> Message-ID: References: <009501c43c1f$63d39580$b103a8c0@krabuzin> <40AB35D3.2070602@adelis.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: QUOTED-PRINTABLE X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/188 X-Sequence-Number: 17901 Thank you very much, but the database I'm using is not mine .... that's why I cannot change anything .... If I wont manage to write this replace function, I'll probably use this solution ... so thank you best regards R. K. On Wed, 19 May 2004, [ISO-8859-1] Beno=EEt BOURNON wrote: > I try to reencode postgresql db ... all is running ... in your shell : > > - pg_dump db -f fileout > > - iconv fileout i do not remember parameters but iconv converts the file. > > - createdb db -U unicode (for example) > > - pgsql db < fileout_converted > > > We change previous year the encoding of this website : www.ape-europe.org > 'iso' to 'utf8' for problems of eastern countries ... > all is running ... > > maybe you can try ... > > Kornelije wrote: > > > Hi, > > > > I need to write a function which has to replace a character with two > > or three other characters .... > > > > I have some data in the DB and when I retrieve this data, I have > > sorting problems because I use specific Croatian characters .... > > I know that the DB is not setup properly, but I cannot change anything > > now because some data could be lost .... > > > > So I need to change specific Croatian characters with some other > > standard characters in order to sort the data properly .... > > > > so, if anybody knows something or has such function, please, let me > > know .... > > > > thanks > > > > R.K. > >