I am using postgres 8.1 for windows and have the
I have 2 databases, one encoded in UTF-8 and one in
In both DBs I can create the following test table:
CREATE TABLE "holaniño"
Then in both DBs I can execute the following SQL:
select * from holaniño where titúlo = 'compania'
HOWEVER, when I change the SQL to:
select * from holaniño where titúlo = "compañia"
(changed the N to a Ñ in the filter)
I receive the error msg:
ERROR: invalid UTF-8 byte sequence detected near byte
Where in the LATIN9 db, there is no problem.
Isn't UTF-8 the same as UNICODE where it encapsulates
all other coding schemes including latin9?
Any insight would be greatly apreciated.
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
pgsql-sql by date
|Next:||From: Markus Schaber||Date: 2006-08-30 08:26:04|
|Subject: Re: UTF8 Vs Latin9 and valid encoding.|
|Previous:||From: codeWarrior||Date: 2006-08-29 18:15:33|
|Subject: Re: to get DD-MM-YYYY format of data|