How can I make record searches case-insensitive

Started by nathanmickler, October 24, 2012, 03:36:33 PM

Previous topic - Next topic

nathanmickler

Is there a way to make the record searching on a domain case-insensitive?

Right now when I do a search for ns I find ns3, but not NS1 or NS2.

- Nathan

matt

My solution to is to always enter DNS records in all lower case. Always, alway, always.

This does highlight an interesting problem. The behavior used to be case insensitive searches, assuming one used the default latin collation in their SQL tables. Newer versions of NicTool have updated the SQL tables to be CHARSET=utf8 COLLATE=utf8_bin. 

The UTF charset is necessary because of the brave new world of International Domain Names with UTF characters. The collation however, could be changed to 'utf8_general_ci' or 'utf8_unicode_ci' perhaps, and that should result in case insensitive searches (the little _ci at the end) like you want.