Non latin1 cahracters, again

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
cujoi
Posts: 1
Joined: Tue 28 Nov 2006 09:01

Non latin1 cahracters, again

Post by cujoi » Tue 28 Nov 2006 09:26

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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 28 Nov 2006 14:17

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

Post Reply