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 <pg...@j-davis.com> 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 > >