[GRASS-user] v.in.db accept DECIMAL'S?

[Jhon Ortiz]

Hi all,

I'm trying to create a new vector (points) map from a mysql database table

v.in.db --overwrite table=data_wells driver=mysql
database="host=localhost,dbname=Eoceno" x=Este y=Norte z=Salinity_Index
key=Cat output=Pozos  

but I get this error:

WARNING: MySQL driver: column 'Salinity_Index', type 246 is not supported
Writing features...
Segmentation fault

In my MySQL database table "Salinity_Index" are decimals numbers and the column type is "DECIMAL(6,3) NULL"My question is, Can I work with decimals number in module v.in.db?

Need I work with decimals numbers in other column type, maybe FLOAT, DOUBLE?

I'm using GRASS 6.4.0RC3 in ubuntu Hardy and MySQL 5.0.51a-3ubuntu5.4

Some advice?

Regards,


John Ortiz
Bioestratigraphic Group - ICP

Bogotá-Colombia


_________________________________________________________________
Más rápido, sencillo y seguro. Descárgate ya el nuevo Internet Explorer 8 ¡Es gratis!
http://www.vivelive.com/ie8 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20090407/742c4818/attachment.html