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 14F7AD1B524
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 19 May 2004 07:24:20 -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 36562-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 19 May 2004 07:24:02 -0300 (ADT)
Received: from neptune.adelis.net (neptune.adelis.net [195.115.171.102])
	by svr1.postgresql.org (Postfix) with ESMTP id 9532AD1B262
	for <pgsql-sql@postgresql.org>; Wed, 19 May 2004 07:23:58 -0300 (ADT)
Received: from [195.115.171.16] (ben.adelis.net [195.115.171.16])
	by neptune.adelis.net (Postfix) with ESMTP
	id 47DA579576; Wed, 19 May 2004 12:09:29 +0200 (CEST)
Message-ID: <40AB35D3.2070602@adelis.com>
Date: Wed, 19 May 2004 12:24:19 +0200
From: =?ISO-8859-1?Q?Beno=EEt_BOURNON?= <benoit.bournon@adelis.com>
User-Agent: Mozilla Thunderbird 0.6 (X11/20040502)
X-Accept-Language: fr, en
MIME-Version: 1.0
To: Kornelije <krabuzin@foi.hr>
Cc: pgsql-sql@postgresql.org
Subject: Re: Replace function ...
References: <009501c43c1f$63d39580$b103a8c0@krabuzin>
In-Reply-To: <009501c43c1f$63d39580$b103a8c0@krabuzin>
Content-Type: multipart/alternative;
	boundary="------------040407010604050501030203"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.4 tagged_above=0.0 required=5.0 tests=HTML_30_40,
	HTML_MESSAGE, HTML_TITLE_EMPTY
X-Spam-Level: *
X-Archive-Number: 200405/178
X-Sequence-Number: 17892

This is a multi-part message in MIME format.
--------------040407010604050501030203
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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.


--------------040407010604050501030203
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
I try to reencode postgresql db ... all is running ... in your shell :<br>
<br>
- pg_dump db&nbsp; -f fileout<br>
<br>
- iconv fileout i do not remember parameters but iconv converts the
file.<br>
<br>
- createdb db -U unicode (for example)<br>
<br>
- pgsql db &lt; fileout_converted<br>
<br>
<br>
We change previous year the encoding of this website :
<a class="moz-txt-link-abbreviated" href="http://www.ape-europe.org">www.ape-europe.org</a><br>
'iso' to 'utf8' for problems of eastern countries ...<br>
all is running ...<br>
<br>
maybe you can try ... <br>
<br>
Kornelije wrote:
<blockquote cite="mid009501c43c1f$63d39580$b103a8c0@krabuzin"
 type="cite">
  <meta http-equiv="Content-Type" content="text/html; ">
  <meta content="MSHTML 6.00.2800.1400" name="GENERATOR">
  <style></style>
  <div><font face="Arial" size="2">Hi,</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">I need to write a function which has
to replace a character with two or three other characters ....</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">I have some data in the DB and when
I retrieve this data, I have sorting problems because I use specific
Croatian characters ....</font></div>
  <div><font face="Arial" size="2">I know that the DB is not setup
properly, but I cannot change anything now&nbsp;because some data could be
lost&nbsp;....</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">So I need to change specific
Croatian characters with some other standard characters in order to
sort the data properly ....</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">so, if anybody knows something or
has such function, please, let me know ....</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">thanks</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">R.K.</font></div>
</blockquote>
</body>
</html>

--------------040407010604050501030203--