From: Benoît BOURNON <benoit.bournon@adelis.com>
To: Kornelije <krabuzin@foi.hr>
Cc: pgsql-sql@postgresql.org
Subject: Re: Replace function ...
Date: Wed, 19 May 2004 12:24:19 +0200
Message-ID: <40AB35D3.2070602@adelis.com> (raw)
In-Reply-To: <009501c43c1f$63d39580$b103a8c0@krabuzin>
References: <009501c43c1f$63d39580$b103a8c0@krabuzin>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: benoit.bournon@adelis.com, krabuzin@foi.hr
Subject: Re: Replace function ...
In-Reply-To: <40AB35D3.2070602@adelis.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox