Polish letter from MySql database in C#

Question

User558783729 posted

Hello.

I want to connect to MySql database. In the properties of the database through SQL Manager I see the database is coded character set latin1 (ISO 8859-1 West European). At the time when the sql to execute commands remotely via EMS i no get the polish world. 

Now i want to only read some data from myssql using MySql connector:

<add assembly="MySql.Data, Version=6.1.2.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>

How to get polish worlds from mySql database in C# Visual Studio web project on aspx page ?

Answer 1

User558783729 posted

I tried to use enconding but all the characters (replace the bushes on my character to "?")

 Encoding encoding = Encoding.GetEncoding ( "iso-8859-1");
        Encoding2 encoding = Encoding.GetEncoding ( "utf-8");
        byte [] result;
        byte [] source;
        source = encoding2.GetBytes (DropDownList1.SelectedValue.ToString ());
        result = Encoding.Convert (encoding2, encoding, source);
        string test1 = encoding.GetString (result);