Re: INET_ATON

2001-08-07 Thread Siim Einfeldt aka Itpunk
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

Re: INET_ATON

2001-08-07 Thread Ian Barwick
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

RE: INET_ATON

2001-08-07 Thread Basil Hussain
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

RE: INET_ATON

2001-03-21 Thread Don Read
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

Re: INET_ATON

2001-03-21 Thread Benjamin Pflugmann
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

Re: INET_ATON

2001-03-21 Thread Peter Pentchev
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