Re: [SQL] Replace function ...

2004-05-21 Thread Kornelije Rabuzin
: 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

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 parameters

[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

Re: [SQL] SELECT - ORDER BY Croatian characters ....

2004-05-10 Thread Kornelije Rabuzin
with this database and it cannot be changed .so I've to found some other solution .. so if you know if it's feasible to write some function.. thank you very much ;-) Kornelije On Fri, 7 May 2004, Peter Eisentraut wrote: Kornelije wrote: I'm using PostgreSQL and my database

[SQL] SELECT - ORDER BY Croatian characters ....

2004-05-07 Thread Kornelije
equivalents and sorting order was ok; since now I'musing PHP, is it feasible to write such a function or is there a better solution? thanks Kornelije