From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Cleaning up a text import |
Date: | 2013-06-29 03:58:20 |
Message-ID: | 51CE5B5C.9000107@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2013-06-29 03:59:58 | Re: [GENERAL] pg_upgrade -u |
Previous Message | John R Pierce | 2013-06-29 02:22:50 | Re: Postgres case insensitive searches |