Converting MDB File With Unicode Characters

[Tomer]

Hey,

I'm using C# wrapper of GDAL and I'm having a problem converting MDB file that contains unicode characters.

Lets take for example conversion to KML file, non-English characters are replaced by '?'

How do I solve it?

[Even Rouault-2]

Selon Tomer <[hidden email]>:

> Hey,
>
> I'm using C# wrapper of GDAL and I'm having a problem converting MDB file
> that contains unicode characters.
>
> Lets take for example conversion to KML file, non-English characters are
> replaced by '?'

Did you try with ogr2ogr first ? To check if the issue is in the ODBC driver (is
that the one that is used actually, since both the ODBC or Java-based MDB driver
could be used), or with the C# bindings, or with your code

>
> How do I solve it?
>
>
>
> --
> View this message in context:
>
http://osgeo-org.1560.x6.nabble.com/Converting-MDB-File-With-Unicode-Characters-tp5158087.html
> Sent from the GDAL - Dev mailing list archive at Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>


--
Spatialys - Geospatial professional services
http://www.spatialys.com
_______________________________________________
gdal-dev mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/gdal-dev

[Tomer]

i tried the vector utility program "ogr2ogr" to convert mdb to kml and still non-English characters are replaced by '?'

[Even Rouault-2]

Selon Tomer <[hidden email]>:

> i tried the vector utility program "ogr2ogr" to convert mdb to kml and still
> non-English characters are replaced by '?'

So the problem is likely in the ODBC driver that doesn't return UTF-8 encoding.

>
>
>
> --
> View this message in context:
>
http://osgeo-org.1560.x6.nabble.com/Converting-MDB-File-With-Unicode-Characters-tp5158087p5158156.html
> Sent from the GDAL - Dev mailing list archive at Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>


--
Spatialys - Geospatial professional services
http://www.spatialys.com
_______________________________________________
gdal-dev mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/gdal-dev

[Tomer]

Do you have any idea for a possible solution?

[Even Rouault-2]

Le lundi 25 août 2014 16:45:00, Tomer a écrit :
> Do you have any idea for a possible solution?

What is the output of ogrinfo on the MDB ? In which encoding does it return
its results ?

>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Converting-MDB-File-With-Unicode-Chara
> cters-tp5158087p5158179.html Sent from the GDAL - Dev mailing list archive
> at Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

--
Spatialys - Geospatial professional services
http://www.spatialys.com
_______________________________________________
gdal-dev mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/gdal-dev

[Tomer]

The ogrinfo display non-English characters as '?'. I'm not sure in which encoding it return its results. (Is there any way to check the encoding?)

Example for ogrinfo output:
                  .
OGRFeature<poly_mdb_23>:4
OBJECTID <Integer> = 3
                   .
                   .
????_?? <String> = -?????
                   .

[Even Rouault-2]

Selon Tomer <[hidden email]>:

> The ogrinfo display non-English characters as '?'. I'm not sure in which
> encoding it return its results. (Is there any way to check the encoding?)

For example, if you do "ogrinfo the_arguments > somefile.txt" and open it with
Notepad++, you can try different options in the Encoding menu to find which one
displays the file correctly.

>
> Example for ogrinfo output:
>                   .
> OGRFeature<poly_mdb_23>:4
> OBJECTID <Integer> = 3
>                    .
>                    .
> ????_?? <String> = -?????
>                    .
>
>
>
> --
> View this message in context:
>

http://osgeo-org.1560.x6.nabble.com/Converting-MDB-File-With-Unicode-Characters-tp5158087p5158293.html
> Sent from the GDAL - Dev mailing list archive at Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>


--
Spatialys - Geospatial professional services
http://www.spatialys.com
_______________________________________________
gdal-dev mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/gdal-dev

[Tomer]

i tried different options in the Encoding menu but none displayed the file correctly. I think the problem is caused by incorrect reading of the mdb file made ​​by the driver.

[Even Rouault-2]

Le mardi 26 août 2014 12:33:49, Tomer a écrit :
> i tried different options in the Encoding menu but none displayed the file
> correctly. I think the problem is caused by incorrect reading of the mdb
> file made ​​by the driver.

You could open a ticket in Trac (see "Submit a new bug report" on
http://trac.osgeo.org/gdal/wiki) with a sample mdb attached (attachment size
is limited, so potentially just an extract of it that demonstrate the issue)

>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Converting-MDB-File-With-Unicode-Chara
> cters-tp5158087p5158338.html Sent from the GDAL - Dev mailing list archive
> at Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

--
Spatialys - Geospatial professional services
http://www.spatialys.com
_______________________________________________
gdal-dev mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/gdal-dev