Skip site navigation (1) Skip section navigation (2)

UTF8 Vs Latin9 and valid encoding.

From: "Marcelo (dot)" <wachaca(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: UTF8 Vs Latin9 and valid encoding.
Date: 2006-08-30 04:48:53
Message-ID: (view raw or whole thread)
Lists: pgsql-sql
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
In both DBs I can create the following test table:

CREATE TABLE "holaniño"
  nombre varchar(5),
  "titúlo" varchar(10)

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 SchaberDate: 2006-08-30 08:26:04
Subject: Re: UTF8 Vs Latin9 and valid encoding.
Previous:From: codeWarriorDate: 2006-08-29 18:15:33
Subject: Re: to get DD-MM-YYYY format of data

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group