|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
1200+ fellow developers rate and compare features of the top IDEs, like Visual Studio, Eclipse, RAD, Delphi and others, across 13 categories. Enjoy this FREE Download of the IDE User Satisfaction Study by Evans Data Corporation. Download Now!
|
|
#1
May 9th, 2000, 01:00 PM
|
|||
|
|||
|
Does anybody know if there's anything special to consider when importing floating point values? I have imported a text file containing such values (like '518,99', german style with comma) and mysql seems to round them. Do i just have to convert it to '518.99' (american style)? However, the comma is recognized correctly as the floating point... but, the values get rounded.
|
|
#2
May 10th, 2000, 08:00 AM
|
|||
|
|||
|
Actually, no, it isn't interpreting the comma correctly and it isn't rounding. MySQL does not recognize the comma as a valid character for numerical data input so it ignores it and everything after it.
I'm not sure if there is a setting to change the decimal character from a . to a , or not but it seems to me this would be likely. Check the MySQL docs.
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > Importing floating point values |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
