Components for Delphi and C++ Builder.

Go to Russian forum
Go to EhLib.com
It is currently 28 Mar 2024, 10:18

All times are UTC




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Filter Accent Insesitive
PostPosted: 15 Nov 2018, 12:57 
Offline

Joined: 22 Apr 2012, 18:35
Posts: 21
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


Top
 Profile  
 
PostPosted: 20 Nov 2018, 14:17 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
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?

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 20 Nov 2018, 20:27 
Offline

Joined: 22 Apr 2012, 18:35
Posts: 21
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


Top
 Profile  
 
PostPosted: 20 Nov 2018, 20:57 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello

What Delphi or Win32 comparison functions support Accent Insensitive?
We should use standard functions.

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 62 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group