cannot replace diacritics ( ّ) sign in arabic

Question

User2131089582 posted

I cannot replace diacritics ( ّ) sign in arabic, but i can replace the letter arabic 

Here is i can replace letter م
select REPLACE(mRoot.Name,N'م','') as Name
from ArabRootModels mRoot
where mRoot.Name=N'يُمَّ'

but when i tried to replace diacritics ( ّ) sign it does not replace it

here is the code
select REPLACE(mRoot.Name,N' ّ','') as Name
from ArabRootModels mRoot
where mRoot.Name=N'يُمَّ'

is there proble with my code to replace with diacritics , Thanks

Answer 1

User1724605321 posted

Hi hocamahdi99,

Do you try something like below to apply an explicit collation 

SELECT 'àéêöhello!' Collate SQL_Latin1_General_CP1253_CI_AI

I am afraid the ` ّ` won't accept in simple query in sql .

Best Regards,

Nan Yu