Re: [ADMIN] [GENERAL] postgres & server encodings

2005-08-09 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > The problem only shows up when you have mixed data -- say, you have two > applications, one website in PHP which inserts data in Latin-1, and a > Windows app which inserts in UTF-8. In this case your data will be a > mess to fix, and there's no way a si

Re: [ADMIN] [GENERAL] postgres & server encodings

2005-08-09 Thread Alvaro Herrera
On Tue, Aug 09, 2005 at 12:56:37PM -0400, Joel Fradkin wrote: > Not that I am an expert or anything, but my initial data base was SQLASCII > and I did have to convert it to Unicode. > My reasons were we store French characters in our database and the newer > odbc driver was not displaying them corr

Re: [ADMIN] [GENERAL] postgres & server encodings

2005-08-09 Thread Joel Fradkin
DMIN] [GENERAL] postgres & server encodings "Salem Berhanu" <[EMAIL PROTECTED]> writes: > What exactly is the SQL_ASCII encoding in postgres? SQL_ASCII isn't so much an encoding as the declaration that you don't care about encodings. That setting simply disables