[mapguide-users] Mgos reading oracle column incorrectly

Marius_360 marius at openspatial.co.za
Mon Jun 2 03:34:50 EDT 2008


I thought something like this as well, I will try this but the problem is
that I cannot change anything in the DB but at least this will help in
finding the problem.



zspitzer wrote:
> 
> looks like its displaying the ascii value... maybe try adding a
> varchar2(1) column with
> the same value and see if that displays correctly?
> 
> On Mon, Jun 2, 2008 at 5:09 PM, Marius_360 <marius at openspatial.co.za>
> wrote:
>>
>> Hi All
>>
>> I have an Oracle table with a geometry column, which I display in mgos
>> successfully. But one of the columns are not being read correctly, for
>> instance the column contains the values 'W', 'H', 'S' and so on, but mgos
>> is
>> reading it as '82', '83' ect.
>>
>> This is a big problem as my layer filter is built from this column and
>> there
>> is a show info with the values of this column, so it is not working. I am
>> using mgos 2.0 and Oracle 10gR2 on Windows server 2003 and IIS with the
>> latest Sl-king providers, the column data type is CHAR(1).
>>
>> Anybody got any ideas as this is a really big problem,
>>
>> Regards,
>>
>> Marius
>> --
>> View this message in context:
>> http://www.nabble.com/Mgos-reading-oracle-column-incorrectly-tp17595252p17595252.html
>> Sent from the MapGuide Users mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
> 
> 
> 
> -- 
> Zac Spitzer -
> http://zacster.blogspot.com (My Blog)
> +61 405 847 168
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Mgos-reading-oracle-column-incorrectly-tp17595252p17595614.html
Sent from the MapGuide Users mailing list archive at Nabble.com.



More information about the mapguide-users mailing list