You can refer : http://www.postgresql.org/docs/9.2/static/multibyte.html
On Fri, Sep 6, 2013 at 11:26 AM, Beena Emerson memissemer...@gmail.comwrote:
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
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
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
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
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
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
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=#
Hi,
Tip:
To identify what encoding you enter in the psql command interpreter:
1) Open a file with vim
2) Type in you SQL or copy/paste
3) Save the file and quit vim
4) $ file filename
Should give you the encoding of that text file.
For ex:
sf@orca:~$ echo $LC_ALL
en_US.UTF-8
sf@orca:~$ cat