I have a mysql table with a double field and a simple form created with Yiic to manage the table, if I insert in the field a number with more 6 decimal digits for example 9,1234567 when I save the number it is rounded after the sixth decimal, so it is saved as 9,123457. I try also with a float field and it saves maximum 5 decimals (always rounded).

I don't understand if this is a problem of Yii or a php problem or mysql problem. I found on the web that there was such a bug in php 5.2.1 version (it saved maximum 6 decimals), but I have the latest version of php (5.2.9) and mysql (5.1.36), and moreover if I use phpmyadmin all decimals are saved correctly. (could be a problem of pdo?)

Someone can try if they have the same problem? thanks