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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly