Re: encoding bug or feature?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
Cc: Jorge Godoy <jgodoy(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: encoding bug or feature?
Date: 2006-07-11 17:03:47
Message-ID: 20838.1152637427@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2006-07-11 17:07:43 Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Previous Message Joshua D. Drake 2006-07-11 16:42:59 Re: pgsql vs mysql