That is up to 64k bytes, not chars, which might not be the same thing if
UNICODE is used using utf-8/utf-16 or ucs-2 for example. Although this
is usually not an issue in the specific case of an URL.
/Karlsson
Johan Höök wrote:
Hi Peter,
I'd thought I'd just mention that the varchar length
Hi,
URL's have a practical limit of 2083 characters it seems. To store
these in a space efficient way (I have 1,000,000s of url rows), what's
the best approach? varchar has a 255 maximum, right? Should I just use
TEXT? I'm not searching *in* the urls, I am selecting like this:
where url = 'xxx'.
Hi Peter,
I'd thought I'd just mention that the varchar length
depends on your MySQL version and character set.
5.0.3 and later handles upto 64k chars.
See: http://dev.mysql.com/doc/refman/5.0/en/char.html
/Johan
Peter Van Dijck skrev:
Hi,
URL's have a practical limit of 2083 characters it
Peter Van Dijck wrote:
Hi,
URL's have a practical limit of 2083 characters it seems. To store
these in a space efficient way (I have 1,000,000s of url rows), what's
the best approach? varchar has a 255 maximum, right? Should I just use
TEXT? I'm not searching *in* the urls, I am selecting like
the urls never repeat. and it's a very active table so I don't wanna
compress right now.
And you're right, most URLs are 255chars, but some are bigger, so
can't use varchar.
I guess I'll just use TEXT :)
Thanks!
Peter
On 9/12/06, Mike Wexler [EMAIL PROTECTED] wrote:
Peter Van Dijck wrote: