;
Sent: Thursday, February 08, 2001 1:15 AM
Subject: RE: Bug converting string into integer
> > 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 a
> 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;
> +
om: Federico Giannici [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 09:09
> To: MySQL mailinglist
> Subject: Bug converting string into integer
>
>
> In a SELECT I have to convert a string into a number.
>
> I used to use something like 'string
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
