search

andrewblake1 / WorksManagement

Project/Works management system for Northpower's Westcoast Energy
0 stars 3 forks source link

Remove case sensitivity off ajax search #404

Closed hawea closed 10 years ago

hawea commented 10 years ago

To recreate issue, please go to this link: http://dev.melbourne.wcewm.co.nz/SubAssembly/admin?parent_assembly_id=1283

Click on +New Then search by "detail" Next search by "Detail"

You will see that it will only find it when you have the capitals correct.

andrewblake1 commented 10 years ago

@hawea. I am not finding any issue here. I have set the database to use utf8 unicode character set with case insenstive collation. The unicode character set allows extended characters, and case insensitive collation should mean any comparison operations are done in case insenstive manner.

I have tried your suggested tests up top and do not get the same result you are describing - please confirm and close if non issue or elaborate further i.e. are there some other conditions that are perhaps making this appear case sensitive to you but not me?

andrewblake1 commented 10 years ago

@hawea check resolved and close