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

2009-02-12 Thread Frank Warmerdam
Gregor Fikoczek wrote: 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. ... So is there any option i got to set or a wor

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

2009-02-10 Thread 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) Featu

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

2009-02-10 Thread 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: