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
