[mapguide-users] Mgos reading oracle column incorrectly

[Marius_360]

yes, I will file a bug. Thanks for the help, I will change it to varchar for
now, till this problem is sorted.


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