Skip to content
Advertisement

SQL server Nvarchar parameters

I Have created an SP to search against many tables in the db based on string sent form ado

the Vb code

and the SQL SP is :

As you can see I have declared argument in VB as Nvarchr and SQL parameter @SearchKey as Nvarchar also if I send english data in @SearchKey search returns correct data, but if I tried to send arabic string in @SearchKey no results appeared knowing that there is arabic data inside the table

Am I missing something?

What Should I do further than that to allow arabic search?

Advertisement

Answer

You can try specifying a collation using the COLLATE keyword:

You’d need to specify arabic afterwards, for instance: COLLATE arabic_ci_as

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement