Re: [GENERAL] psql file restore - problem with encoding (solved)

2005-03-16 Thread Miroslav Åulc
We have solved the problem. Maybe someone will face the same problem so just to close this thread, the problem was in php.ini where a default output character set was set which caused the "second" recoding problem (just for display using php). Miroslav Åulc wrote: Hi all, I have problem on one

Re: [GENERAL] psql file restore - problem with encoding

2005-03-16 Thread John DeSoi
On Mar 16, 2005, at 9:34 AM, Miroslav Šulc wrote: I have problem on one of our potentional client's linux server with data encoding. I have played with this for some time but with no success. Here is the problem: Maybe try setting the client side encoding explicitly at the top of the dump file:

Re: [GENERAL] psql file restore - problem with encoding

2005-03-16 Thread Miroslav Šulc
John DeSoi wrote: On Mar 16, 2005, at 9:34 AM, Miroslav Šulc wrote: I have problem on one of our potentional client's linux server with data encoding. I have played with this for some time but with no success. Here is the problem: Maybe try setting the client side encoding explicitly at the top

Re: [GENERAL] psql file restore - problem with encoding

2005-03-16 Thread Miroslav Åulc
Just update - the system is Fedora Core 2, but the PostgreSQL is compiled from sources. Miroslav Åulc wrote: Hi all, I have problem on one of our potentional client's linux server with data encoding. I have played with this for some time but with no success. Here is the problem: I have dump fi

[GENERAL] psql file restore - problem with encoding

2005-03-16 Thread Miroslav Åulc
Hi all, I have problem on one of our potentional client's linux server with data encoding. I have played with this for some time but with no success. Here is the problem: I have dump file created with pg_dump on my dev linux machine (PostgreSQL 8.0.1). When I upload the file to the client's ser