Re: Indexing beyond 100 charaters

In article <#0v5bJxnIHA.940@news-server>, buzon[NO]@evilfoto.es says...
> 
> 
> I use a lot the longggggggggg links to web sites
> normally of more than 100 characters.
> 
> Also people put files in very long paths to put their files
> 
> 
> Since there is a limit on indexing a character field of 100
> characters I wonder how complicated it would be to
> extend that limit to the field limit of a table 254 characters.
> 
> At least it would help.

Unless you have a LOT of URLs that are identical for the first 100 
characters, you really won't gain much by indexing all 254 characters.  
You can still use fields longer than that, and index them if you use 
only the first 100 chars in the index expression.


-- 
Remove the ns_ from if replying by e-mail (but keep posts in the 

I use a lot the longggggggggg links to web sites
normally of more than 100 characters.

Also people put files in very long paths to put their files


Since there is a limit on indexing a character field of 100
characters I wonder how complicated it would be to
extend that limit to the field limit of a table 254 characters.

At least it would help.

Emilio