Re: [NOVICE] Understanding Encoding

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Beena Emerson <memissemerson(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: [NOVICE] Understanding Encoding
Date: 2013-09-06 07:14:18
Message-ID: CA+HiwqE=FJUujoXd8yJDxfkDpr7MAxcua7VnaKO125jLc8mjAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

On Fri, Sep 6, 2013 at 3:47 PM, Beena Emerson <memissemerson(at)gmail(dot)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 client_encoding;
> client_encoding
> -----------------
> EUC_KR
> (1 row)
>
> korean=# INSERT INTO tbl VALUES ('그레스');
> ERROR: invalid byte sequence for encoding "EUC_KR": 0xa0 0x88

I changed the encoding of the terminal emulator (GNOME Terminal
2.31.3) using the Terminal menu as:

Terminal -> Set Character Encoding -> Korean (EUC-KR)

Note that, if the menu only lists UTF-8, you'd have to add EUC-KR
using "Add or Remove".

And it seems to work; could you try the same?

--
Amit Langote

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Beena Emerson 2013-09-06 07:24:27 Re: [SQL] Understanding Encoding
Previous Message Tatsuo Ishii 2013-09-06 07:03:12 Re: Understanding Encoding

Browse pgsql-sql by date

  From Date Subject
Next Message Beena Emerson 2013-09-06 07:24:27 Re: [SQL] Understanding Encoding
Previous Message Tatsuo Ishii 2013-09-06 07:03:12 Re: Understanding Encoding