[mapguide-users] Mgos reading oracle column incorrectly

Haris Kurtagic haris at sl-king.com
Mon Jun 2 07:17:59 EDT 2008


Sorry, I missed all this conversation.
I would just addd it is not bug it is by design.
Perhaps we could chnaged that, I am just not sure if I remember
correctly but I think we have an database with byte values stored in
CHAR(1).

Haris

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Zac Spitzer
Sent: Monday, June 02, 2008 9:55 AM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] Mgos reading oracle column incorrectly

As this is FDO related, it might make sense to post this over on the
fdo-users list as well,

z

On Mon, Jun 2, 2008 at 5:52 PM, Marius_360 <marius at openspatial.co.za>
wrote:
>
> 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-tp17595252p
17595252.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-tp17595252p
17595746.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-tp17595252p
17595878.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


More information about the mapguide-users mailing list