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/ _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users