[gdal-dev] ogr 1.6 and ArcSDE 9.3sp1: not reading varchar2 fields

[Duarte Carreira]

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)