Re: [SQL] Replace function ...

2004-05-21 Thread Kornelije Rabuzin
thanks If I don't find some other solution, I'll do it . so, thanks ... best regards Kornelije On Wed, 19 May 2004, BenLaKnet wrote: > I try to reencode postgresql db ... all is running ... in your shell : > > - pg_dump db -f fileout > > - iconv fileout i do not remember paramete

Re: [SQL] Replace function ...

2004-05-21 Thread Kornelije Rabuzin
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ît BOURNON wrote: > I try to r

Re: [SQL] Replace function ...

2004-05-20 Thread Benoît BOURNON
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 webs

Re: [SQL] Replace function ...

2004-05-17 Thread Yasir Malik
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I need to write a function which has to replace a character with two or three other > characters > You can use the replace function as specified below: replace(string text, from text, to text) text Replace all occurrences in @string of substr

[SQL] Replace function ...

2004-05-17 Thread Kornelije
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