The Network People Support Forums

Other TNPI Software => NicTool => Topic started by: nathanmickler on October 24, 2012, 03:36:33 PM

Title: How can I make record searches case-insensitive
Post by: nathanmickler on October 24, 2012, 03:36:33 PM
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
Title: Re: How can I make record searches case-insensitive
Post by: matt on October 24, 2012, 04:12:59 PM
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.