EhLib.Com
https://forum.ehlib.com/en/

Filter Accent Insesitive
https://forum.ehlib.com/en/viewtopic.php?f=5&t=872		 Page 1 of 1
Author:  arnikos [ 15 Nov 2018, 12:57 ]
Post subject:  Filter Accent Insesitive
Memtable has the Propetry Options.mtoTextFieldsCaseInsesitive which, if set to True, Filtering records is Case Insesitive.
Is it possible to have another Option mtoAccentInsesitive so as filtering is Accent Insesitive?

Thanks
Nicholas
Author:  EhLibSupport [ 20 Nov 2018, 14:17 ]
Post subject:  Re: Filter Accent Insesitive
Hello Nicholas

Sorry for delay.
Could you write detail info or ref to an article where would explain in detail what is "filtering with Accent Insensitive".
Does this concept apply to any language?
Does Delphi have functions to work with Accent Insensitive?
Author:  arnikos [ 20 Nov 2018, 20:27 ]
Post subject:  Re: Filter Accent Insesitive
Hello,

my native language is Greek which has the following vowels:
α, ε, η, ι, ο, υ, ω and the corresponding accented vowels ά, έ, ή, ί, ό, ύ, ώ and also ϊ, ϋ, ΐ, ΰ (But I think that the French and German languages have their own accented vowels).
I have a SQLServer Database with Collation Greek_CI_AI and when execute a Query with the following SQL:

select name from employees
where
name='Παπάς'

the result recordset contains the
name
Παπάς ->exactly the same
παπάς ->First character Case Insesitive
Παπας ->4th Character Accent Insesitive
παπας ->First character Case Insesitive - 4th Character Accent Insesitive
and everything is OK.

What I want, is filtering memtable the same way.
For example if I set Dataset.Filter: name='Παπάς', I want the same result as above.

Thanks
Nicholas

PS. If you Google 'Filtering Accent Insesitive' you will find many articles
Author:  EhLibSupport [ 20 Nov 2018, 20:57 ]
Post subject:  Re: Filter Accent Insesitive
Hello

What Delphi or Win32 comparison functions support Accent Insensitive?
We should use standard functions.
Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/