Devart Forums

Hi,

I've read the FAQ and searched through already posted topics, however I still can't solve my problem.

I am trying to store slovenian characters into a database via stored procedures, something like this:


MySqlCommand command = new MySqlCommand();
command.Connection = dh.conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "sp_insert";
command.ParameterCheck = true;

MySqlParameter p_param= new MySqlParameter();
p_param.ParameterName = "p_param";
p_param.Value = "蚞ȊŽ";
command.Parameters.Add(p_param);

dh.conn.Open();
int nRet = command.ExecuteNonQuery();
dh.conn.Close();



I've tried setting connection.Unicode=true, I've tried to use different encodings on the tables in the database, I've tried the SET NAMES utf8;, but no matter what I do, some characters just turn into question marks.

Any ideas on what to do?

David

Please provide your client and server machines' regional settings and your MySQL Server settings.