Link to home
Start Free TrialLog in
Avatar of fpoyavo
fpoyavoFlag for United States of America

asked on

MS SQL 2005 insert collation KOI8 does not show characters

Hi Experts,

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 ?

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of fpoyavo
fpoyavo
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fpoyavo

ASKER

also I have found something similar discussed at : http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2324456&SiteID=17
Avatar of fpoyavo

ASKER

From my understanding it has to be some kind encoding / decoding class to convert it. Any ideas ? Samples for this specific case.