INET6
Topics on This Page:
- In 10.5 ES, 10.5 CS:
Stores an INET6 or mapped INET4 network address as a BINARY(16) internally while translating it into a CHAR(39) to the user.
- In 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
Not present
See also: Data Types in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
DETAILS
CHANGE HISTORY
Release Series |
History |
---|---|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXAMPLES
CREATE TABLE inet6_example (
description VARCHAR(20),
example INET6
);
INSERT INTO inet6_example VALUES
('Normal', '2001:db8::ac43:20e5'),
('Long', '2001:0db8:0000:0000:0000:0000:ac43:20e5'),
('Hex', 0x20010db80000000000000000ac4320e5),
('IPv4 mapped', '::ffff:192.0.2.42'),
('IPv4 compatible', '::192.0.2.42');
SELECT * FROM inet6_example;
+-----------------+---------------------+
| description | example |
+-----------------+---------------------+
| Normal | 2001:db8::ac43:20e5 |
| Long | 2001:db8::ac43:20e5 |
| Hex | 2001:db8::ac43:20e5 |
| IPv4 mapped | ::ffff:192.0.2.42 |
| IPv4 compatible | ::192.0.2.42 |
+-----------------+---------------------+
EXTERNAL REFERENCES
Information specific to MariaDB SkySQL can be found on the INET6 page in the SkySQL Documentation.