Hi list, i got some new
By generating GML from oracle, i first have to set the NLS_LANG-Parameter: export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 ogrinfo OCI:************* -sql "SELECT * from test_decimal_values" Layer name: SELECT * from test_decimal_values Geometry: Unknown (any) Feature Count: 1 Layer SRS WKT: (unknown) ID: Integer (2.0) COL1: Real (0.0) COL2: Real (6.4) OGRFeature(SELECT * from test_decimal_values):0 ID (Integer) = 1 COL1 (Real) = 12.3456 COL2 (Real) = 12.3456 => So now everythin is fine with the GML from the data source oracle ######################################## So I got now only the problem with MySQL and the float column: MySQL: col1 float OGR: col1 (Real) = 12 col1 (Real) = 12 (Real Value (every column) in the databese: 12.1234) Any idea? Best Regards, Greq Am Dienstag 10 Februar 2009 10:22:07 schrieb Gregor Fikoczek: > Hi list, > > i got a problem by generating a GML-File from the Oracle- and MySQL-DB > using ogr2ogr, so I alway getting in MySQL/oracle instead of a float-value > an rounded integer-value (mostly 0) without any decimal numbers. > > Some Info: > > ################################# > > Structure MySQL: > > ID smallint(6) > col1 float > col2 float(8,4) > col3 double > col4 double(8,4) > col5 decimal(10,0) > col6 decimal(6,4) > > using ogrinfo/ogr2ogr with MySQL: > > ogrinfo MYSQL:******** -sql "SELECT * from test_decimal_values" > > OGRFeature(sql_statement):3 > ID (Integer) = 3 > col1 (Real) = 12 > col2 (Real) = 12 > col3 (Real) = 12 > col4 (Real) = 12 > col5 (Real) = 12 > col6 (Real) = 12.1234 > > c > > => Only the values of column col6 [ decimal(6,4)] are right interprated, > what about the other decimal value in ogr ???? > => My real column is like the col1-column [float] > > ################################# > > Structure Oracle: > > ID NUMBER(2,0) > COL1 NUMBER > COL2 NUMBER(6,4) > > > using ogrinfo/ogr2ogr with Oracle: > > ogrinfo OCI:********** -sql "SELECT * from test_decimal_values" > > Feature Count: 1 > Layer SRS WKT: > (unknown) > ID: Integer (2.0) > COL1: Real (0.0) > COL2: Real (6.4) > > OGRFeature(SELECT * from test_decimal_values):0 > ID (Integer) = 1 > COL1 (Real) = 12 > COL2 (Real) = 12.0000 > > Real Value (every column) in the databese: 12.3456 > > > => No column-values are right interprated, so what about the decimal value > in ogr ???? > => My real column is like the col1-column [NUMBER] > > > ################################# > > So is there any option i got to set or a workaround for that problem, > aspacialy in oracle? > > > Best regards, > Greq > > > > --------------------------------------- > WhereGroup GmbH & Co. KG > Siemensstraße 8 > 53121 Bonn > Germany > > Gregor Fikoczek > Email: [email protected] > Fon: +49 (0)228 / 90 90 38 - 25 > Fax: +49 (0)228 / 90 90 38 - 11 > > [email protected] > www.wheregroup.com > Amtsgericht Bonn, HRA 6788 > ------------------------------- > Komplementärin: > WhereGroup Verwaltungs GmbH > vertreten durch: > Olaf Knopp, Peter Stamm > --------------------------------------- > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev -- Mit freundlichen Grüßen / Kind regards Gregor Fikoczek --------------------------------------- WhereGroup GmbH & Co. KG Siemensstraße 8 53121 Bonn Germany Gregor Fikoczek Email: [email protected] Fon: +49 (0)228 / 90 90 38 - 25 Fax: +49 (0)228 / 90 90 38 - 11 [email protected] www.wheregroup.com Amtsgericht Bonn, HRA 6788 ------------------------------- Komplementärin: WhereGroup Verwaltungs GmbH vertreten durch: Olaf Knopp, Peter Stamm --------------------------------------- _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
