Behavior geographical generates latitude FLOAT(18, 2), longitude FLOAT(18, 2) - it's not exact

This change doesn't fix the problem. The problem here is that float and double types default to (18,2) for no good reason. See line 233: http://trac.doctrine-project.org/browser/branches/1.2/lib/Doctrine/DataDict/Mysql.php?rev=7253

I think u need to let the default mysql float and double types be set if options are not specified explicitly for length/scale. This problem causes all doubles and floats to have poor 2 decimal precision.

Doctrine always sets the default if nothing is specified currently so we can't change that we can set our own length and scale though. However, I don't know what proper values would be. I'll do some tests and report back, let me know if you have any additional information. Thanks, Jon

Well it seems that Doctrine sets the default to 18,2 but afaik that is not necessary. I would suggest that if no scale is specified then the data type is simply defined as FLOAT or DOUBLE with no scale. This works fine for Mysql in my project.

On Symfony 1.4.8 / Mysql it is still not working
Setting to
type: float(18), scale: 6
enhances precission, but the numbers are rounded weirdly in the database:
for example 76.86 is stored as 76.860001
I really would appreciate a true mysql float!!!

Still broken on 1.2.4 the last release of 1.2 unfortunately. This is the fix I used:

Change line 239 of lib/Doctrine/DataDict/Mysql.php from:

return 'DOUBLE('.$length.', '.$scale.')';

to

return 'DOUBLE';

This gets rid of scale completely but I think its better than all doubles that don't have a defined scale limited to decimal places, which is just awful for anyone using the Geographical behaviour.