Wrong string to integer conversion ?

[tuxshadow]

Hi

can someone explain me why these two statement returns different
values ?

select convert('023',integer)

return 19

select convert('023',double)

return 23

I'm running version 1.1.115 on java 1.6.0_13

Thanks in advance

E.

[Johann Schleier-Smith]

In the first case, the leading '0' indicates an octal representation of the number.

[Thomas Mueller]

Hi,

I will add this to the documentation of CAST:

"When converting a text to a number, the default Java conversion
rules are used (prefixes 0x or # for hexadecimal numbers, prefix 0 for
octal numbers)."

Regards,
Thomas

[Chad McHenry]

Is there a reason why converting to integer honors octal formatting, but converting to double does not?

[Thomas Mueller]

Hi,

H2 uses

http://java.sun.com/javase/6/docs/api/java/lang/Double.html#valueOf(java.lang.String)
http://java.sun.com/javase/6/docs/api/java/lang/Long.html#decode(java.lang.String)

Regards,
Thomas