I'm correcting the subject of the message - the problem is with NVARCHAR fields (not varchar2). It seems this relates to utf issues/limitations in ogr.
If I could use SQL functions this could be solved by the database itself. Like using TO_CHAR(field_name) or TRANSLATE(field_name USING CS_CHAR). But it seems ogr does not support these sql functions/operators... Any additional suggestions? Thanks, Duarte -----Mensagem original----- De: Duarte Carreira [mailto:dcarre...@edia.pt] Enviada: quinta-feira, 26 de Março de 2009 23:54 Para: gdal-dev@lists.osgeo.org Assunto: [gdal-dev] ogr 1.6 and ArcSDE 9.3sp1: not reading varchar2 fields Hello. As always trying to coerce these two to work together nicely... The situation: exporting ArcSDE feature class to <anything>, shapefile, gpx... server: Oracle xe (10), ArcSDE 9.3 sp1, Win2003 Std x32 client: Vista x32, GDAL/OGR 1.6 build 1500 from Tamas site, sde dll's from 9.3 sp1 As you can see below, Oracle describes several fields as being number and nvarchar2, and ogrinfo only identifies numeric fields. All text fields come out as unknown. Now, what could this be due to? Anyone facing the same issue? I tried to use SQL to cast a nvarchar to character without success... Thanks, Duarte Feature class description in Oracle: Column Name Data Type Nullable Default Primary Key OBJECTID NUMBER No - - IDPERC NVARCHAR2(6) Yes - - NOME NVARCHAR2(150) Yes - - DESCRICAO NVARCHAR2(255) Yes - - IDPONTO NVARCHAR2(10) Yes - - IDSIG NUMBER Yes - - XCOORD NUMBER(38,8) Yes - - YCOORD NUMBER(38,8) Yes - - MORADA_COMPLETA NVARCHAR2(255) Yes - - CONCELHO NVARCHAR2(50) Yes - - FREGUESIA NVARCHAR2(50) Yes - - CODPOSTAL NVARCHAR2(10) Yes - - TELEFONE NVARCHAR2(10) Yes - - DESCRICAOPT NVARCHAR2(255) Yes - - NOMEPT NVARCHAR2(150) Yes - - SHAPE ST_GEOMETRY Yes - - 1 - 16 ogrinfo output: Layer name: <user>.<table> Geometry: Unknown (any) ERROR 1: SE_layer_get_statistics: -51/Underlying DBMS error Feature Count: -1 Extent: (6177.862000, -123296.045000) - (63997.354000, -91245.397000) Layer SRS WKT: PROJCS["Datum_73_Hayford_Gauss_IPCC", GEOGCS["GCS_Datum_73", DATUM["Datum_73", SPHEROID["International_1924",6378388.0,297.0]], PRIMEM["Greenwich",0.0], UNIT["Degree",0.0174532925199433]], PROJECTION["Transverse_Mercator"], PARAMETER["False_Easting",180.598], PARAMETER["False_Northing",-86.99], PARAMETER["Central_Meridian",-8.131906111111112], PARAMETER["Scale_Factor",1.0], PARAMETER["Latitude_Of_Origin",39.66666666666666], UNIT["Meter",1.0]] OBJECTID: Integer (10.0) IDPERC: (unknown) (6.0) NOME: (unknown) (50.0) DESCRICAO: (unknown) (50.0) IDLINHA: (unknown) (5.0) SHAPE_LENG: Real (38.8) _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
