GDAL's driver georaster not support the Chinese?

[bicealyh]

when my Oracle NLS_LANG is SIMPLIFIED CHINESE_CHINA.ZHS16GBK. It give me error:OCI_NEED_DATA. After I change the Oracle NLS_LANG to AMERICAN_AMERICA.US7ASCII. It give me some result like that insert or regestering VAT ERROR. So I think the GDAL's driver georaster not support the Chinese. The import raster data to Oracle georaster result like below:

D:\georasterProj>gdal_translate -of georaster
 D:\image2\Extract_20.img georaster:system/123,,city_images,image -co "DESCRIPTI
ON=(image_id NUMBER, img_des VARCHAR2(45), image MDSYS.SDO_GEORASTER)" -co "INSE
RT=VALUES(3,'IMG',SDO_GEOR.INIT('city_images_rdt',3))" -co "BLOCKXSIZE=512" -co
"BLOCKYSIZE=512" -co "COMPRESS=DEFLATE"
Input file size is 8534, 6478
ERROR 1: ORA-01036: illegal variable name/number

ERROR 1: ORA-01036: illegal variable name/number

ERROR 1: ORA-06550: line 143, column 57:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the follow
ing:

   ( begin case declare end exception exit for goto if loop mod
   null pragma raise return select update while with
   <an identifier> <a double-quoted delimited-identifier>
   <a bind variable> << continue close current delete fetch lock
   insert open rollback savepoint set sql execute commit forall
   merge pipe purge

ERROR 1: Insert/registering VAT Error!
ERROR 1: ORA-01036: illegal variable name/number

ERROR 1: ORA-01036: illegal variable name/number

ERROR 1: ORA-06550: line 143, column 55:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 143, column 3:
PL/SQL: SQL Statement ignored
ORA-06550: line 143, column 54:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the follow
ing:

   ;

ERROR 1: Insert/registering VAT Error!
ERROR 1: ORA-01036: illegal variable name/number

ERROR 1: ORA-01036: illegal variable name/number

ERROR 1: ORA-06550: line 144, column 1:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the follow
ing:

   ( begin case declare end exception exit for goto if loop mod
   null pragma raise return select update while with
   <an identifier> <a double-quoted delimited-identifier>
   <a bind variable> << continue close current delete fetch lock
   insert open rollback savepoint set sql execute commit forall
   merge pipe purge

ERROR 1: Insert/registering VAT Error!
0...10...20...30...40...50...60...70...80...90...100 - done.
Ouput dataset: (georaster:system,123,,CITY_IMAGES_RDT,3) on CITY_IMAGES,IMAGE

[warmerdam]

Ivan,

Thoughts?

[ilucena]

There are some problem with locale settings and we are working on it. Thank you very much for sharing with us.

The original error OCI_NEED_DATA, I believe was related to the simple process of writing the XML metadata. I did a little experiment a couple of days ago:

http://trac.osgeo.org/gdal/changeset/17403

I replaced a "GR1.metadata := XMLTYPE(:1)" with a binder by a simple "GR1.metadata := XMLTYPE(%s)" on georaster_wrapper.cpp.

Could you confirm that you are using that latest code from the trunk? After that could you change back to Chinese and try again with a raster image that doesn't have attribute table? I think you could remove the RAT just by translating to GTIFF or JPEG.

The VAT error is another problem. I believe you mentioned on OTN Forum that you are going to upload a file sample to ftp.geosofti.com. I am download it now. Thanks.

Ivan

[ilucena]

I've got your sample data. Thanks.

The problem is that I should recognize that your RAT is just a histogram and I should not try to load it as a GeoRaster VAT. But even if I load it. I should work properly.

It looks like that file was generated by ESRI software. That could make things a little bit difficult to identify what is a legitimate VAT since they don't document it very well. I will see what I can do.

[ilucena]

I have solved the problem related to VAT on r17421.

The support for Chinese language is still not fixed.

[ilucena]

Committed revision 17479