在C＃西里尔编码 [英] Cyrillic encoding in C#

问题描述

我有一个MSSQL数据库一堆西里尔般的文字，需要将其转换为西里尔在C＃。

所以...Ðàáîòàâãåðìàíèè

应成为

Работавгермании

有什么建议？

我要补充一点，我已经得到最接近的是什么？aaioa A AA？iaiee

这里的code我使用的是：

 海峡= Encoding.UTF8.GetString(Encoding.GetEncoding(\"Windows-1251\").GetBytes(drCurrent[\"myfield\"].ToString()));
 海峡= Encoding.GetEncoding（1251）.GetString（Encoding.Convert（Encoding.UTF8，Encoding.GetEncoding（1251），Encoding.UTF8.GetBytes（STR）））;
 

解决方案

  //要找出源和目标
常量字符串源=Ðàáîòàâãåðìàíèè
常量字符串目的地=Работавгермании的foreach（在Encoding.GetEncodings变种sourceEncoding（））
{    。VAR字节= sourceEncoding.GetEncoding（）GetBytes会（源）;
    的foreach（在Encoding.GetEncodings变种targetEncoding（））
    {
        如果（targetEncoding.GetEncoding（）。GetString的（字节）==目的地）
        {
            Console.WriteLine（源编码：{0} TargetEncoding：{1}。，sourceEncoding codePAGE，targetEncoding codePAGE）;
        }    }
}//结果1：信源编码：1252 TargetEncoding：1251
//结果2：信源编码：28591 TargetEncoding：1251
// Result3：信源编码：28605 TargetEncoding：1251//将code供您使用
VAR德codedCyrillic = Encoding.GetEncoding（1251）.GetString（Encoding.GetEncoding（1252）.GetBytes（源））;
//结果：Работавгермании
 

I have a bunch of Cyrillic-like text in a MSSQL database and need to convert it to Cyrillic in C#.

So... Ðàáîòà â ãåðìàíèè

should become

Работа в германии

Any suggestions?

I should add that the closest I've gotten is ?aaioa a aa?iaiee

Here's the code I'm using:

 str = Encoding.UTF8.GetString(Encoding.GetEncoding("Windows-1251").GetBytes(drCurrent["myfield"].ToString()));
 str = Encoding.GetEncoding(1251).GetString(Encoding.Convert(Encoding.UTF8, Encoding.GetEncoding(1251), Encoding.UTF8.GetBytes(str)));

解决方案

// To find out source and target
const string source = "Ðàáîòà â ãåðìàíèè";
const string destination = "Работа в германии";

foreach (var sourceEncoding in Encoding.GetEncodings())
{

    var bytes = sourceEncoding.GetEncoding().GetBytes(source);
    foreach (var targetEncoding in Encoding.GetEncodings())
    {
        if (targetEncoding.GetEncoding().GetString(bytes) == destination)
        {
            Console.WriteLine("Source Encoding: {0} TargetEncoding: {1}",sourceEncoding.CodePage,targetEncoding.CodePage);
        }

    }
}

// Result1: Source Encoding: 1252 TargetEncoding: 1251
// Result2: Source Encoding: 28591 TargetEncoding: 1251
// Result3: Source Encoding: 28605 TargetEncoding: 1251

// The code for you to use 
var decodedCyrillic = Encoding.GetEncoding(1251).GetString(Encoding.GetEncoding(1252).GetBytes(source));
// Result: Работа в германии

这篇关于在C＃西里尔编码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！