Re: character set problem

[saad alhokail]

hi
i have the same problem with charset cp1256 in beta 1 and 2.
in beta 1 dataset loading the data ok in firset time but when i try to reloading it i got error msg say (character 'cp1256' not supported),but in beta 2 the dataset can't loading data and directly printing (character 'cp1256' not supported) msg.

i was try with UTF-8 and i get character index 195 error.

so,is there any solutions ?

*************
System info:
windows 2000 SP4 arabic
.NET 1.1
MySql 4.1.3b

---snipt code ----------------------------
myDataSet = new DataSet();

string connection = "Database=vote_system;Data source=localhost;UserId=root;Password=saadgo;";
string query = "select * from voters ";

MySqlConnection conn = new MySqlConnection(connection);

MySqlDataAdapter adapter = new MySqlDataAdapter();

adapter.SelectCommand = new MySqlCommand(query, conn);

adapter.Fill(myDataSet);
}
catch(System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);

}
------------------------------------------