Appropriate SQL type for variable length url's and descriptions?

Question

I have a small db app that stores URL's of all lengths, some extremely long (hundreds of characters) and some of typical length (< 50 characters). Am I introducing inefficiencies into the DB by declaring VARCHAR(1000) (or higher) as the type? Is there something better to use?

zerkms · Accepted Answer · 2010-08-11 23:50:32Z

2

http://www.boutell.com/newfaq/misc/urllength.html

As for me - I'm sure 1000 chars is quite enough for any url

answered Aug 11, 2010 at 23:50

zerkms

256k73 gold badges447 silver badges551 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joe Koberg · Accepted Answer · 2010-08-12 00:12:42Z

0

Depends on your RDMBS. In PostGreSQL you use type TEXT for variable length strings.

answered Aug 12, 2010 at 0:12

Joe Koberg

27k6 gold badges50 silver badges54 bronze badges

Collectives™ on Stack Overflow

Appropriate SQL type for variable length url's and descriptions?

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related