CODEWITHSUNDEEP
windowspostgresqlpsqlpostgresql-9.3pgadmin-4
shani
shani

Reputation: 1

foreign languages in PSQL data

I searched a lot about this, but didn't find anything - How can I support more languages in postgres?

If I upload text in Hebrew, it stores it in the database as ??????.

How can I get Postgres to store my data correctly?

Upvotes: 0

Views: 248

Answers (1)

Jasen
Jasen

Reputation: 12392

Postgresql text (and char) columns are (natively) UTF8 and can store any combination of Unicode code points (characters).

If you are seening ????? then your interface used to store or retreive the data is misconfigured.

I did the following using psql on linux (so configured for unicode out of the box) it's probably harder to do this on windows.

jasen=# create table presidents(name text);
CREATE TABLE
jasen=# insert into presidents values ('יצחק "בוז׳י" הרצוג');
INSERT 0 1
jasen=# select * from presidents;
        name        
--------------------
 יצחק "בוז׳י" הרצוג
(1 row)

Upvotes: 1

Related Questions