Re: ERROR: invalid byte sequence from psql - Works perfectly from pgAdmin III query window

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='...'

Yours,
Laurenz Albe