Re: Postgres GIS Question

[akp geek <akpgeek@xxxxxxxxx>]

We are getting the data by invoking a webservice in which I found these strange characters. we have a job that takes the data from XML and dumps into our tables. What I am guessing is, it should be fixed at the source. If that's not possible, I might have to take it some how?

Regards

On Tue, Mar 9, 2010 at 4:53 PM, Jeff Davis <pgsql@xxxxxxxxxxx> wrote:

On Tue, 2010-03-09 at 16:27 -0500, akp geek wrote:
>               we have are using postgis. I am running into this
> scenarios. When the query is executed it is displaying information as
> " 780/24 520 (500- ? ) " as opposed to " 780/24 520 (500- 1/4  )" .
> It's doing in many part. Has any one run into this kind of issue? Is
> it related to the encoding by any chance? Can you please share your
> thoughts?

You haven't really provided enough information to begin. What is the
server_encoding? What is the client_encoding? How are you putting the
data in? What kind of special characters are you using, and what do you
expect the result to be?

Regards,
       Jeff Davis