On Monday, December 26, 2011 9:32:41 pm Adarsh Sharma wrote:
> Thanks for the Explaination,
> I find it hard to determine the way to store data in different encodings
> to store in postgresql, below is the demo of some data :-
>
> INSERT INTO conceptnet_frame
> VALUES(3884,'ja','{1}?{2}???????',16,3,2140,NULL,NULL,NULL);
> INSERT INTO conceptnet_frame
> VALUES(3885,'ja','{1}?{2}??????????',31,3,2140,NULL,NULL,NULL);
> Below link explains all the things :-
> http://www.depesz.com/index.php/2010/03/07/error-invalid-byte-sequence-for-
> encoding/
>
> Above link shows the above encoding schemes is in utf16 format but
> postgresql-8.4 doesn't support it.
> Is there any way to store data in different encoding in a utf-8 database.
Use iconv or recode to convert the UTF16 to UTF8 first.
>
> Happy Holidays!
>
--
Adrian Klaver
adrian.klaver@gmail.com