[mapguide-users] Mgos reading oracle column incorrectly

[Zac Spitzer]

Can you file a bug @ http://trac.osgeo.org/fdo/ against the KingOracle Provider?

You could create a view which cast's the value as a varchar value, you
just need
to create a record under sdo_geom_metadata for the view as well.

z

On Mon, Jun 2, 2008 at 5:44 PM, Marius_360 <marius at openspatial.co.za> wrote:
>
> 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.
>
> _______________________________________________
> 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