Re: encoding bug or feature? - Mailing list pgsql-general

From Tom Lane
Subject Re: encoding bug or feature?
Date
Msg-id 20838.1152637427@sss.pgh.pa.us
Whole thread Raw
In response to Re: encoding bug or feature?  (marcelo Cortez <jmdc_marcelo@yahoo.com.ar>)
Responses Re: encoding bug or feature?  (marcelo Cortez <jmdc_marcelo@yahoo.com.ar>)
List pgsql-general
marcelo Cortez <jmdc_marcelo@yahoo.com.ar> writes:
> testutf8=# \set
> ...
> ENCODING = 'UTF8'
> HISTSIZE = '500'
> testutf8=# select upper('�');
> ERROR:  invalid UTF-8 byte sequence detected near byte
> 0xf1
> testutf8=#

You're telling the system that your client encoding is utf8, but
it looks from here like you're using some LatinN encoding.
Try "\encoding latin1" or whatever it is your keyboard is generating.

            regards, tom lane

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: pgsql vs mysql
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pgsql vs mysql