Hello Erkan, On Sep 4, 2012, at 11:34 , erkan yanar wrote:
> On Mon, Sep 03, 2012 at 07:19:45PM +0200, Peter van Dijk wrote: >> OUR QUESTIONS: >> 1b. Is VARBINARY the best way to do it for MySQL? > > Afaik you want only to have the ordering (collation) to be binary. So you > have some ways to do it without touching the character set. > 1. SELECT .. ORDER BY BINARY > Just change the Query This, presumably, rules out index usage, which is bad. > 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! Kind regards, -- Peter van Dijk Netherlabs Computer Consulting BV - http://www.netherlabs.nl/ _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
