Re: [SQL] [NOVICE] Understanding Encoding

2013-09-06 Thread Beena Emerson
On Fri, Sep 6, 2013 at 12:29 PM, Tom Lane wrote: > Beena Emerson 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 VAL

Re: [SQL] [NOVICE] Understanding Encoding

2013-09-06 Thread Amit Langote
On Fri, Sep 6, 2013 at 3:47 PM, Beena Emerson 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=# SHO

Re: [SQL] [NOVICE] Understanding Encoding

2013-09-05 Thread Tom Lane
Beena Emerson 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 encoding "EUC_KR":

Re: [SQL] [NOVICE] Understanding Encoding

2013-09-05 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=

Re: [SQL] [NOVICE] Understanding Encoding

2013-09-05 Thread Amit Langote
On Fri, Sep 6, 2013 at 2:56 PM, Beena Emerson 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 table and > inserte