Thread: Postgres GIS Question
Hi all -
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?
Regards
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?
Regards
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
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@j-davis.com> wrote:
You haven't really provided enough information to begin. What is theOn 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?
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