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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> >> 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 <[EMAIL PROTECTED]> >>>>> 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 >>>>>> [email protected] >>>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Zac Spitzer - >>>>> http://zacster.blogspot.com (My Blog) >>>>> +61 405 847 168 >>>>> _______________________________________________ >>>>> mapguide-users mailing list >>>>> [email protected] >>>>> 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 >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> >> >> >> >> -- >> Zac Spitzer - >> http://zacster.blogspot.com (My Blog) >> +61 405 847 168 >> _______________________________________________ >> mapguide-users mailing list >> [email protected] >> 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. > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > -- Zac Spitzer - http://zacster.blogspot.com (My Blog) +61 405 847 168 _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
