thanks for your reply, I've tried but with no success. It seems there is no way to directly perform an accent insensitive research with Select() function in a DataTable as like as in sql environment. could somebody suggest a workaround?

hi, I've this problem : we work with a sql database which operates in accent-insensitive mode, once I've cached some data from it to my .NET application, how can I search within this data (contained in a DataTable) with an accent-insensitive query? I mean I'd like to obtain the same result (i.e.) " André " in any case if user is searching for: DataTable.Select("name LIKE 'andré') DataTable.Select("name LIKE 'andrè') DataTable.Select("name LIKE 'andre') thanks to anyone may answer Darx

Hi, and thanks for reply. You have right. Why don't try? The truth is that I was almost sure this configuration was working on my test server... but today doesn't work anymore... While I keep switched off TCP protocol of sql server, I can not access it from asp.net web applications. the result is "Server doesn't exist or access denied". I am little bit confused... I can't tell if this configuration should work or not... About connection string I was asking someone if there are a specific one using "Shared Memory" access mode. anyone is experienced? thanks again

Hi. I've this question: I have IIS (and dot net environment) and MS SQL msde on same machine (MS Windows 2000 server). For security reason I've switched off all network protocols of Sql. (sql is listening on shared memory) Is it still possible to connect to sql (not using odbc) ?? I nedd to modify my ADO.NET connection string? Could someone showme an exemple? thanks to anyone.

set COLLATION parameter when you run msde Setup : setup COLLATION="Latin1_General_CI_AI" DATADIR="C:\" TARGETDIR="C:\Programmi\Microsoft SQL Server\" /L*v C:\msdelog.txt SAPWD="[your passw]" Latin1_General_CI_AI means Case_Insensitive Accent_Insensitive you can specify also CI_AI_KI for Katana an so on.. option not specified means default value. darx