[bind10-dev] scalability issue with SQL(ite3) select with 'like'

[Stephen Morris]

On 05/03/2012 19:10, JINMEI Tatuya / 神明達哉 wrote:
> At Mon, 5 Mar 2012 11:09:37 +0100, João Damas <joao at bondis.org>
> wrote:
> 
>> you would probably be better off with varchar(255) for a domain
>> name or varchar(63) for a label rather than generic TEXT
> 
> Perhaps, but we cannot simply assume the max length is 255 (or 63) 
> because it's a textual representation and could contain something
> like '\DDD'

Looking again at this email made me ask the question why we don't
store the the binary representation of the name in the database, and
only convert to and from the text representation when we need to?

Stephen