Why I can't store INET_ATON result to VARBINARY(4)?

Question

MySQL documentation says that: Data type VARBINARY(16) is for IPv6 addresses and data type VARBINARY(4) is for IPv4 addresses.

But when I try to store INET_ATON result to VARBINARY(4) column, I get the following error message:

Data too long for column varbinary(4)

Storing INET_ATON result to VARBINARY(16) is OK!

What's wrong?

score 1 · Answer 1 · answered Jun 22 '20 at 09:37

1

To store values generated by INET_ATON(), use an INT UNSIGNED column (…)

answered Jun 22 '20 at 09:37

Mike Doe

It says it in following context: `use an INT UNSIGNED column rather than INT, which is signed`. And MySQL UNSIGNED INT size is exactly 4 bytes (like VARBINARY(4)). – NoSkill Jun 22 '20 at 09:51
1

@NoSkill Is there some problem with doing what it says in the documentation? – user207421 Jun 22 '20 at 10:16
It's a good question though @NoSkill. Did you try casting the result? – Mike Doe Jun 22 '20 at 10:52
So... Should I EXPLICIT cast result of INET_ATON to VARBINARY(4)? – NoSkill Jun 22 '20 at 12:18

1 Answers1