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
