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

[Duarte Carreira]

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:DCarreira at edia.pt]
Enviada: quinta-feira, 26 de Março de 2009 23:54
Para: gdal-dev at 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)