[mapguide-users] Mgos reading oracle column incorrectly

[Marius_360]

I have tested that with the VARCHAR2 and it does display the correct value.
So the problem is the CHAR data type. Is there any way that I can get around
this other than changing the column datatype? As I said earlier I may not
really change the DB on the client's side.


Marius_360 wrote:
> 
> 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-tp17595252p17595746.html
Sent from the MapGuide Users mailing list archive at Nabble.com.