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

Re: [SQL] Understanding Encoding

2013-09-05 Thread Gopal Tandon
You can refer : http://www.postgresql.org/docs/9.2/static/multibyte.html On Fri, Sep 6, 2013 at 11:26 AM, 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 ha

[SQL] Understanding Encoding

2013-09-05 Thread Beena Emerson
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 inserted some korean value into it. =# CREATE DATABASE korean WITH ENCOD

[SQL] Don't miss this

2013-09-05 Thread Sandy
Hey, how are you? I've lost 10lbs since using this. http://j.mp/14IpV2H Try it for free, I promise it's the best. Let me know how well it works for you!