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 ...
> 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 ....
In response to
pgsql-sql by date
|Next:||From: Christoph Haller||Date: 2004-05-19 10:55:22|
|Subject: Re: a wierd query|
|Previous:||From: Richard Huxton||Date: 2004-05-18 18:56:22|
|Subject: Using "Without OIDs"|