Maximum Length Of IP Address: 15 (IPv4) & 39(IPv6)

Posted by Gopinath on Tech Dreams See other posts from Tech Dreams or by Gopinath
Published on Thu, 27 Jan 2011 02:38:00 +0000 Indexed on 2011/01/28 23:35 UTC
Read the original article Hit count: 294

Filed under:

SQL Server

|

programming

Problem

You are designing a database table for a web application that requires to store IP address of users who visits the site. The IP address is required to be stored a character data in the table. To define size of the character column you need to know maximum length of IP address. So, what is the maximum length of an IP address?

Solution

The IPv4 version of IP address is in the following format

255.255.255.255

To store IPv4 address we require 15 characters.

The IPv6 version of IP address is grouped into sets of 4 hex digits separated by colons, like the below

2001:0db8:85a3:0000:0000:8a2e:0370:7334

To store IPv6 address you require a 39 characters long column.

Conclusion

As IPv4 and IPv6 are the commonly use protocols, you better define a column with 39 characters length so that both the format address are saved in to the table without any issues.

This article titled,Maximum Length Of IP Address: 15 (IPv4) & 39(IPv6), was originally published at Tech Dreams. Grab our rss feed or fan us on Facebook to get updates from us.

© Tech Dreams or respective owner

Related posts about SQL Server

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Concat Function in SQL Server – SQL Concatenation

as seen on SQL Authority - Search for 'SQL Authority'
Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though… >>> More
How can I detect which version of SQL (eg SQL 2008 or SQL Azure)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure. How can I do this with detection code written in SQL? >>> More
Nested SQL Select statement fails on SQL Server 2000, ok on SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is the query: INSERT INTO @TempTable SELECT UserID, Name, Address1 = (SELECT TOP 1 [Address] FROM (SELECT TOP 1 [Address] FROM [UserAddress] ua INNER JOIN UserAddressOrder uo ON ua.UserID = uo.UserID WHERE ua.UserID = u.UserID ORDER BY uo.AddressOrder ASC) q ORDER BY AddressOrder… >>> More
Putting data from local SQL database to remote SQL database without remote SQL access enabled (PHP)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a local database, and all the tables are defined. Eventually I need to publish my data remotely, which I can do easily with PHPmyadmin. Problem however is that my remote host doesn't allow remote SQL connections at all, so writing a script that does a mysqldump and run it through a client… >>> More

Related posts about programming

Imperative Programming v/s Declarative Programming v/s Functional Programming

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Imperative Programming :: Imperative programming is a programming paradigm that describes computation in terms of statements that change a program state. In much the same way as the imperative mood in natural languages expresses commands to take action, imperative programs define sequences of commands… >>> More
Programming in python Vs programming in Java

as seen on Stack Overflow - Search for 'Stack Overflow'
I've been writing Java for the last couple of years , and now I've started to write in python (in addition). The problem is that when I look at my Python code it looks like someone tried to hammer Java code into a python format , and it comes out crappy because - well , python ain't Java. Any… >>> More
Have you ever bought a commercial implementation of a programming language for personal programming

as seen on Stack Overflow - Search for 'Stack Overflow'
Commercial products are often a source of ideas and inspiration for open source projects. There are free and open source implementations of almost every programming language ever devised, and a lot of them are very good. For non-work related personal programming projects, have you ever bought an… >>> More
Is Game Programming very different from normal programming?

as seen on Stack Overflow - Search for 'Stack Overflow'
By normal programming, I'm referring to application programming (which is all I'm familiar with at the moment). My goal is to make games, and I wanted to know if the path was different than other programming paths at the beginner level. Or perhaps it's too early for me to worry about that at this… >>> More
Programming activities for high school kids who have no idea what CS or programming is

as seen on Stack Overflow - Search for 'Stack Overflow'
I work at a small high school that's in a very high poverty area. There are only a handful of seniors that are thinking about applying to be an engineer of some sort in college and only 1 kid that applied for Computer Science (he has a couple acceptances so far!). He's been talking to me a lot as… >>> More