Re: Cleaning up a text import - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Cleaning up a text import
Date
Msg-id 51CE5B5C.9000107@gmail.com
Whole thread Raw
In response to Cleaning up a text import  (Bob Pawley <rjpawley@shaw.ca>)
List pgsql-general
On 06/28/2013 09:36 AM, Bob Pawley wrote:
> Hi
>
> I imported some text using the Quantum GIS dxf2postgiswhich somehow
> became distorted through the import.
>
> What should have been imported was TK-208.
>
> What I got was %%UTK-208%%U.
>
> Perhaps I did something wrong while using dxf2postgis?
>
> Otherwise, I can trim the text using - select trim (both '% U' from
> '%%UTK-208%%U') .
>
> However I would need to know what it is that needs to be trimmed from
> future imports, which isn't always possible.
>
> I would appreciate any suggestions on how to resolve this.

Have not used dxf2postgis, but at a guess the %%U markers are used to
denote Unicode?

Maybe look in the dxf2postgis docs to see what it has to say about encoding?

>
> Many thanks in advance.
>
> Bob
>


--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Postgres case insensitive searches
Next
From: Jeremy Palmer
Date:
Subject: Generate documentation from PL/pgsql source code?