Hello,
Thank you all.
Amit, Changing the encoding of the terminal emulator worked.
Sebastiean, the tip was helpful.
--
Beena Emerson
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
Should give you the encoding of that text file.
For ex:
sf@orca:~$ echo $LC_ALL
en_US.UTF-8
sf@orca:~$ cat /tmp/xx
> 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
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
