Re: [SQL] [NOVICE] Understanding Encoding

2013-09-06 Thread Amit Langote
On Fri, Sep 6, 2013 at 2:56 PM, Beena Emerson memissemer...@gmail.com wrote: Hello All, I am not able to understand how the encoding is handled. I would be happy if someone can tell what is happening in the following scenario: 1. I have created a database with EUC_KR encoding and created a

Re: [SQL] [NOVICE] Understanding Encoding

2013-09-06 Thread Beena Emerson
I wonder if you have tried changing your locale to ko_KR; something like: LANG=ko_KR LC_ALL=ko_KR \ psql -d korean Hi, It still gives same result: $ LANG=ko_KR LC_ALL=ko_KR $ psql -d korean korean=# SHOW client_encoding; client_encoding - EUC_KR (1 row) korean=# INSERT

Re: [SQL] [NOVICE] Understanding Encoding

2013-09-06 Thread Tom Lane
Beena Emerson memissemer...@gmail.com writes: It still gives same result: $ LANG=ko_KR LC_ALL=ko_KR $ psql -d korean korean=# SHOW client_encoding; client_encoding - EUC_KR (1 row) korean=# INSERT INTO tbl VALUES ('그레스'); ERROR: invalid byte sequence for

Re: [SQL] [NOVICE] Understanding Encoding

2013-09-06 Thread Amit Langote
On Fri, Sep 6, 2013 at 3:47 PM, Beena Emerson memissemer...@gmail.com wrote: I wonder if you have tried changing your locale to ko_KR; something like: LANG=ko_KR LC_ALL=ko_KR \ psql -d korean Hi, It still gives same result: $ LANG=ko_KR LC_ALL=ko_KR $ psql -d korean korean=# SHOW

Re: [SQL] [NOVICE] Understanding Encoding

2013-09-06 Thread Beena Emerson
On Fri, Sep 6, 2013 at 12:29 PM, Tom Lane t...@sss.pgh.pa.us wrote: Beena Emerson memissemer...@gmail.com writes: It still gives same result: $ LANG=ko_KR LC_ALL=ko_KR $ psql -d korean korean=# SHOW client_encoding; client_encoding - EUC_KR (1 row) korean=#