I am trying to insert from text file russian / cyrillic collation into database.
I would do the following :
1] while I am reading convert KOI8 collation into cyrillic that is recognized by windows
example : this one is ok KC0K?20@05>50>@502? and .NET VS is saying its unicode
this one is not which is KOI8 cyrillic : ðÒÅÚÉÄÅÎÔ. äÏÒÏÇÏÊ ÍÉÎÉÓÔÒ, ÔÁ ×ÅÌÉËÁÑ ÍÉÓÓÉÑ, ËÏÔÏÒÁÑ
2] my DB MS SQL 2005 has correct setting according to Microsoft : Cyrillic_General_CI_AS
3] my insert is using N'mytext' to enforce Unicode I assume
4] Is there way to convert it on the fly or any other way to see this KOI8 in windows application not
web where you can specify globalization etc ?