I think this is supported from 3.23...not sure though, but might be:-)
> hey folks,
>
> i just tried using INET_ATON() and INET_NTOA() and i keep getting syntax
> errors
>
> near '("100.100.100.100")' at line 1
>
> no manner of quoting that i can think of solves this. i tried the examples
> a
Hi
On Tuesday 07 August 2001 07:23, mike cullerton wrote:
> i just tried using INET_ATON() and INET_NTOA() and i keep getting syntax
> errors
>
> near '("100.100.100.100")' at line 1
>
> no manner of quoting that i can think of solves this. i tried the examples
> at the bottom of http://www.mys
Hi,
> i just tried using INET_ATON() and INET_NTOA() and i keep getting syntax
> errors
> am i missing something easy here? is this a known issue? perhaps a version
> thing? i am running 3.22.32.
Yes, you are missing something. If I may quote from the manual - in section
F.2.20, "Changes in r
On 20-Mar-01 Jason Bell wrote:
> ok... this is stumping me perhaps I'm doing something wring, but It
> doesn't appear that I am
>
> Am I doing, or not doing something that makes the INET_ATON function
> default to 127.255.255.255 ? why does it work for 24.18.10.5, but not
> 192.168.50.5
Hi.
On Tue, Mar 20, 2001 at 02:09:48PM -0800, [EMAIL PROTECTED] wrote:
> ok... this is stumping me perhaps I'm doing something wring, but It
> doesn't appear that I am
>
> Am I doing, or not doing something that makes the INET_ATON function
> default to 127.255.255.255 ?
No, as you shou
It would be my guess that you're trying to store inet_aton()'s value
into a signed integer column, which is in the range of roughly -2G - 2G-1,
while inet_aton()'s result is unsigned, in the range 0 - 4G-1. Whenever
inet_aton() happens to return a value > 2G-1, MySQL truncates it and stores
into