RowFilter - Accent Insensitive with Strings

Hello Folks!

I have a SQL Server table column and two records.
One column have "Porão" and the other "Porao".

I want filter my dataview using the RowFilter property.

example:

dv.RowFilter = "column = 'Porao'"

datagrid.datasource=dv
datagrid.databind();

I need to see two records. But i see only one because the filter use accent
sensitive when searching.

Is there a way to configure the dataset for accent sensitive?

Tks
Robson

ianstirkcv
Wed Sep 24 04:10:44 CDT 2003

Hi,

you could use a variation of the String.CompareOrdinal function. Please see below:


Dim strTest As String = "Ägypten"
Dim strTest2 As String = "Agypten"

If String.CompareOrdinal(strTest, strTest2) Then
MessageBox.Show("Are same")
Else
MessageBox.Show("Are different")
End If



Hope this helps
Ian