Encoding name issue
Posted by: Jorge Estrada
Date: February 28, 2015 11:31PM

I'm using the .Net Connector 6.9.5 on a Windows RT app

The problem is on the Open connection command

string connStr = "server=localhost;user=root;database=world;port=3306;password=******;";
MySqlConnection conn = new MySqlConnection(connStr);

conn.Open();

[error]
'Windows-1252' is not a supported encoding name.
Parameter name: name"
[/error]

[error]
at System.Globalization.EncodingTable.internalGetCodePageFromName(String name)
at System.Globalization.EncodingTable.GetCodePageFromName(String name)
at System.Text.Encoding.GetEncoding(String name)
at MySql.Data.MySqlClient.Driver..ctor(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
[/error]

Even if I set the CharSet to utf-8 (or utf8) ir return an error

If download 6.7.2 from here https://github.com/pdonald/mysql-connector-net you get the same error. So I change all Windows-1252 references to to utf-8 and it works

With that change I was able to connect, retrieve databases and tables but can't make a single SELECT to any table, on any database, on any server

I want to use 6.9.5

What can be wrong ?

Options: ReplyQuote


Subject
Written By
Posted
Encoding name issue
February 28, 2015 11:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.