[gdal-dev] Generating GML from Database - Problem: No decimal values

[Gregor Fikoczek]

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: gregor.fikoczek at wheregroup.com
> Fon: +49 (0)228 / 90 90 38 - 25
> Fax: +49 (0)228 / 90 90 38 - 11
>
> info at wheregroup.com
> www.wheregroup.com
> Amtsgericht Bonn, HRA 6788
> -------------------------------
> Komplementärin:
> WhereGroup Verwaltungs GmbH
> vertreten durch:
> Olaf Knopp, Peter Stamm
> ---------------------------------------
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> 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: gregor.fikoczek at wheregroup.com
Fon: +49 (0)228 / 90 90 38 - 25
Fax: +49 (0)228 / 90 90 38 - 11

info at wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
---------------------------------------