Re: [SQL] UTF8 Vs Latin9 and valid encoding.

2006-08-30 Thread Marcelo .
Hello, Thanks for your reply. When I execute show client_encoding; I get UNICODE. However, up to know I was using pgAdmin III Query and EMS... you gave me the idea to use psql, where I noticed something interesting: \encoding UTF8 show client_encoding; UTF8 So this seems to be OK.. However

Re: [SQL] UTF8 Vs Latin9 and valid encoding.

2006-08-30 Thread Markus Schaber
Hi, Marcelo, Marcelo . wrote: > I receive the error msg: > ERROR: invalid UTF-8 byte sequence detected near byte > 0xf1 > > Isn't UTF-8 the same as UNICODE where it encapsulates > all other coding schemes including latin9? Yes, it is. But it seems that your client and the server disagree on t

[SQL] UTF8 Vs Latin9 and valid encoding.

2006-08-29 Thread Marcelo .
Hello, I am using postgres 8.1 for windows and have the following dilema. I have 2 databases, one encoded in UTF-8 and one in Latin9. In both DBs I can create the following test table: CREATE TABLE "holaniño" ( nombre varchar(5), "titúlo" varchar(10) ) WITHOUT OIDS; Then in both DBs I can