ASP.NET - Arabic search - Asked By mostafa hamdy on 10-Nov-11 06:48 AM

Hello all
I have some web site built in .Net 4.0 and this site have a web page contains a search form have a search feilds with First name , Last Name and Full Name,  users info saved in the DB in Arabic language, the user when try to search   may enter in the text boxes values like  أحمد and ا حمد . The required search must return all records which contain both , please if any body get what I mean and can Help me in doing that please send me or tell me about some URL may help me in doing  that
Regards
Mostafa
Reena Jain replied to mostafa hamdy on 10-Nov-11 07:39 AM
Hi,

Either you need to set the culture for Arabic in your web.config file.
or
add --Locale Identifier-- to the OLEDB connection string!!
to be like this (For Arabic):

Dim odbSearch As OleDbConnection = New OleDbConnection("Provider=MSIDXS;Data Source=custom;Locale
Identifier=1025")
kalpana aparnathi replied to mostafa hamdy on 10-Nov-11 01:07 PM
Try this query:

select * from table_name where name=N@name