Re: ERROR: invalid byte sequence from psql - Works perfectly from pgAdmin III query window - Mailing list pgsql-general

Albe Laurenz skrev:
> Anoo Sivadasan Pillai wrote:
>> Why the Fun_ABC1 is created and Fun_ABC12 is raising the
>> following error, while run through psql, ( I Could create
>> both the functions from PgAdmin III query )
>>
>> ERROR:  invalid byte sequence for encoding "UTF8": 0x93
>
> Because the characters you entered into psql are not
> encoded in the character encoding that psql expects.
>
> You probably create the function in psql by executing an
> SQL script, right?
>
> From the error message I deduce that psql expects UTF8
> characters from you.
>
> You can do two things:
> 1) change the SQL script to UTF8 before running it
> 2) change the client encoding in psql before running the
>    SQL script.
>    This is done with the SQL command
>    SET client_encoding='...'

Third option: Stop using curly quotes in your SQL - even if it just in
comments.

Nis