[mapguide-users] Mgos reading oracle column incorrectly

Marius_360 marius at openspatial.co.za
Mon Jun 2 07:20:23 EDT 2008


Thanks for the explanation. I found the best fix for me is to change data
type to varchar2(1).

Marius.


haris kurtagic wrote:
> 
> Hi,
> Yes, King.Oracle works as you described.
> It maps Oracle Char ( length 1 ) to FDO byte data type. There is no
> single char type in FDO, only string data type.
> 
> One of quick solutions would be to create view or change column type to
> either have length more than 1 or use varchar.
> 
> Haris
> 
> 
> 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Marius_360
> Sent: Monday, June 02, 2008 9:10 AM
> To: mapguide-users at lists.osgeo.org
> Subject: [mapguide-users] Mgos reading oracle column incorrectly
> 
> 
> 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
> _______________________________________________
> 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-tp17595252p17599052.html
Sent from the MapGuide Users mailing list archive at Nabble.com.



More information about the mapguide-users mailing list