When reading data from the "ms SQL server" database, Cyrillic values are displayed incorrectly, for example, ????? ?? ?? ?? ?? ?? ?? ?? ?? ????
If you use the “SQL Server Management Studio”, all this is displayed in the normal form. You can not change the base.
What need to do?
string connectString =@"Integrated Security = SSPI; pooling=false; Initial Catalog =F:\ARCHIVEMANAGER\ALARMLOGGING\ASU_DMPC-HMI_ALG_201207012000_201207031825.MDF; Data Source =FLORES\sqlexpress;" string strSelect = "SELECT Text3, AckType, ServerID FROM [AlgViewRUS_ID] WHERE [Text3] LIKE 'кост%'"; SqlDataAdapter dataAdapter1 = new SqlDataAdapter( strSelect, connectString ); DataSet _ds = new DataSet(); dataAdapter1.Fill( _ds, AlgViewRUS_ID ); datagrid1.ItemsSource = _ds.Tables[AlgViewRUS_ID].DefaultView;