Skip site navigation (1) Skip section navigation (2)

Re: Error while loading sql file

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>, Alban Hertroys <haramrae(at)gmail(dot)com>
Subject: Re: Error while loading sql file
Date: 2011-12-27 14:40:36
Message-ID: 201112270640.36845.adrian.klaver@gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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(dot)klaver(at)gmail(dot)com

In response to

pgsql-general by date

Next:From: Merlin MoncureDate: 2011-12-27 15:16:44
Subject: Re: postgresql triggers - defining a global resource (java)
Previous:From: Filip RembiałkowskiDate: 2011-12-27 12:27:52
Subject: Re: Show <parameter> in psql does any calculations?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group