Re: Querying the schema for column widths - what syntax do I use?

On Fri, Feb 22, 2008 at 11:38:33AM +0000, Howard Wilkinson wrote:
> The package is a DNS server originally hosted on top of a MySQL data
> base. I am extending it in a number of ways, but this particular need
> arises as I need to store some data (binary in nature) in a field that
> is part of the key for an index. The data is < 65536 in length. However,
> most of the time it is <<<<<<65536 e.g. 4 bytes. I also need to support
> backwards compatibility with the previous releases which had limited
> storage capacity in this field.

Just remember that if you're going to index the data that a btree index
will handle a maximum of 2700 *bytes* which, depending on your encoding
might be many less characters. This is independant of the maximum size
of the datatype.

How you deal with this depends on why exactly you want it indexed.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy