« Home

Saving russian data on Sql Server

1) use nvarchar or nchar datatype

2) insert values with N prefix. eg:

insert into tblFoo values(N’слайд’)

2) use N prefix on your select statements.eg:

N’select * from tblFoo’

3) On c# code dont use datatype as DataType.AnsiString use DataType.String instead