Helpful Information
 
 
Category: PostgreSQL Help
inserting unicode char to pgsql db

I'm trying to add other languages to a postgres database

CREATE DATABASE "test" WITH ENCODING = 'UNICODE';

this works and makes the database fine but when trying to insert anything else besides ascii chars I get an error

PostgreSQL said: ERROR: Invalid UNICODE character sequence found (0xe30000)
Your query:
INSERT INTO "ttable" ("tcol") VALUES ('ã')

any help?
thanks










privacy (GDPR)