MySQL Forums
Forum List  »  Newbie

Truncated incorrect DOUBLE value:
Posted by: Derek Meyer
Date: May 04, 2015 03:11PM

I have a question that I cant quite figure out why I am seeing the warning message. While everything is working I just don't get it.

I have a varchar 15 field that stores IPV4 Addresses (I know it should use inet binary) and that process is underway that when ever I issue a select statement similar to

select IP_v4 from Table spits out the answer but also gives the warning of

Warning | 1292 | Truncated incorrect DOUBLE value: '10.11.12.13'

This is a varchar field.. Why would it take it as a double?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Truncated incorrect DOUBLE value:
May 04, 2015 03:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.