[Pdns-users] PowerDNS needs your thoughts on two important DNSSEC matters

[Peter van Dijk]

Hello,

On Sep 4, 2012, at 20:50 , Peter van Dijk wrote:

>> 2. ALTER TABLE records ADD order name      VARCHAR(255) BINARY
>>  Then you don't care about the CHARSET used by the server. 
>>  This syntax always set the binary collation specific for that charset
> 
> This is a good tip I did not know about. I will look into this. The downside of VARBINARY is that queries also become case-sensitive, which is acceptable for PowerDNS but makes debugging harder. Thanks!


This works just as well as VARBINARY, indeed. Sadly, it does also make queries case-sensitive. If anyone has a suggestion that avoids case-sensitivity, please let us know. Otherwise we will go with VARCHAR BINARY. 

Thanks!

Kind regards,
-- 
Peter van Dijk
Netherlabs Computer Consulting BV - http://www.netherlabs.nl/