Hi,

I am having issues while inserting data in postgres which has a character  .
While inserting this character through PGADMIN, it parses the character to ETX, while the pgsql shell parses it to ^C. When I keep the query with character in a file and pass the file in psql shel it gives me an error :

ERROR: invalid byte sequence for encoding "UTF8": 0x82

My Postgres Db encoding is set to UTF-8.

Please let me know how to deal with these kind of characters.

Thanks,
Rohit.

PS: I am not sure if the character can be seen here properly. It is a box drawing character which is represented in
ASCII as 192 and
UTF- 8 as - U+2514