Re: [SQL] Understanding Encoding

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 ENCODING 'EUC_KR' LC_COLLATE='ko_KR.euckr' LC_CTYPE='ko_KR.euckr' TEMPLATE=template0;

=# \c korean

korean=# SHOW client_encoding;

 client_encoding 

-----------------

 UTF8

(1 row)

korean=# CREATE TABLE tbl (doc text);

korean=# INSERT INTO tbl VALUES ('그레스');

2. If I insert non-korean values it throws error:

korean=# INSERT INTO tbl VALUES ('データベース');

ERROR:  character with byte sequence 0xe3 0x83 0xbc in encoding "UTF8" has no equivalent in encoding "EUC_KR"

korean=# SELECT * FROM tbl;

  doc   

--------

 그레스

(1 row)

3. I change the client encoding to EUC_KR and try inserting the same korean characters and it throws an error:

korean=# SET client_encoding = 'EUC_KR';

SET

korean=# INSERT INTO tbl VALUES ('그레스');

ERROR:  invalid byte sequence for encoding "EUC_KR": 0xa0 0x88

Even the SELECT statement displays something different. I am not able to understand why?

korean=# SELECT * FROM tbl;

  doc   

--------

 �׷���

(1 row)

Can someone please help me.

Thanks you,

Beena Emerson