Ron McKeever wrote:
I am storing ips in a mysql 4.0.17 db as int. I am Converting them using
a perl script with inet_aton to create a four-byte string.
My goal:
Is to return the ip as a normal dotted ip for the user to see after a select
statement is done
via a php web page. The ip is entered in
I am storing ips in a mysql 4.0.17 db as int. I am Converting them using
a perl script with inet_aton to create a four-byte string.
My goal:
Is to return the ip as a normal dotted ip for the user to see after a select
statement is done
via a php web page. The ip is entered in as a dotted ip on
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 ca
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 trie
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,
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
at the bottom of http://www.mysql.com/doc/M/i/Miscellaneous_functio
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.
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.
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
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 when inserting into a table
10 matches
Mail list logo
