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
|