From: Marcin W. <wo...@un...> - 2004-09-20 12:36:11
|
Hi, FloatCol uses FLOAT column type for every datebase. In Postgresql FLOAT mean double precision, I think the same in SQLite, but in MySQL FLOAT is single precision. I think it would be better to have double precision in every DB. Patch below works for me. Marcin Index: col.py =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D --- col.py (revision 210) +++ col.py (working copy) @@ -401,6 +401,9 @@ def _sqlType(self): return 'FLOAT' + def _mysqlType(self): + return "DOUBLE PRECISION" + class FloatCol(Col): baseClass =3D SOFloatCol |