fpoyavo
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
From my understanding it has to be some kind encoding / decoding class to convert it. Any ideas ? Samples for this specific case.
ASKER