In a SELECT I have to convert a string into a number.
I used to use something like 'string'+0, where 'string' is a string
rapresentation of an integer.
Now I noticed that in many cases it returns a rounded floating point!!!
For example:
mysql> select '11'+0;
+-----------------+
| '11'+0 |
+-----------------+
| 10.999999046326 |
+-----------------+
1 row in set (0.00 sec)
Is it normal? Or it happens only in my system? (OpenBSD 2.8 i386)
What is the best (more efficient) way to convert an integer string to an
integer value?
Thanks,
___________________________________________________
__
|- [EMAIL PROTECTED]
|ederico Giannici http://www.neomedia.it
___________________________________________________
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
