Author Topic: Make searches diacritic insensitive  (Read 497 times)

skiwi

  • EA Practitioner
  • ***
  • Posts: 1890
  • Karma: +41/-75
    • View Profile
Make searches diacritic insensitive
« on: December 13, 2019, 12:18:32 pm »

Searches (ctrl-F) appear to be case insensitive.
It would also be a modern approach to make searches diacritic insensitive.
E.g. Kotui = kotui = Kōtui
Orthogonality rules
Using EA15.1 (1526) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2014 R2 & Access2003/JET4.0

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 7232
  • Karma: +83/-10
    • View Profile
Re: Make searches diacritic insensitive
« Reply #1 on: December 13, 2019, 02:18:42 pm »
Searches use the collation settings for the database. If you want this behavior you should just need to change your collation in sql server.
Eve

support@sparxsystems.com

skiwi

  • EA Practitioner
  • ***
  • Posts: 1890
  • Karma: +41/-75
    • View Profile
Re: Make searches diacritic insensitive
« Reply #2 on: December 13, 2019, 02:38:58 pm »

Thanks
I went checking on the download page https://www.sparxsystems.com/registered/reg_ea_down.html to find the download on https://www.sparxsystems.com/resources/repositories/index.html
because I thought this would be the sort of thing set in the database creation script, but it isn't apparently.
Orthogonality rules
Using EA15.1 (1526) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2014 R2 & Access2003/JET4.0

skiwi

  • EA Practitioner
  • ***
  • Posts: 1890
  • Karma: +41/-75
    • View Profile
Re: Make searches diacritic insensitive
« Reply #3 on: December 16, 2019, 08:22:50 am »

EA could also provide an option to enable case or accent sensitivity, by appending the collation sequence to the query. viz
Code: [Select]
SELECT name FROM customer ORDER BY name COLLATE Latin1_General_CS_AI; 

I also searched to documentation (e.g. for collation sequence, case insensitivity,  accent insensitivity, case sensitive, accent sensitive) to see if this is mentioned.
Can't find a thing.


So could I suggest that Sparx:
  • mention in installation instructions the impact to DB collation sequence to EA functioning
  • note that good practice is to make searches case and accent insensitive
  • consider adding options to the find (ctrl-F) function to enable to disable case or accent sensitivity
Orthogonality rules
Using EA15.1 (1526) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2014 R2 & Access2003/JET4.0