.NET Connector & Central European fonts (cp1250)

[Janez Praprotnik]

Hello!

I'm using ASP.NET 2003 & .NET Connector 1.0.4. Everything works fine if I use standard latin fonts (latin1) when configuring MySQL server (v. 4.1.10a) but when I reconfigure server and select CE fonts (cp1250), I get strange error that tells me cp1250 font is not supported

This is the error:

Character set 'cp1250' is not supported
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: MySql.Data.MySqlClient.MySqlException: Character set 'cp1250' is not supported

Source Error:


Line 48: Dim da As New MySqlDataAdapter(cmd)
Line 49: Dim dt As New DataTable
Line 50: da.Fill(dt) 'Here is where the exception is thrown
Line 51: Me.txt1.Text = dt.Rows(0)("dd")
Line 52: End Sub


Source File: c:\inetpub\wwwroot\WebApplication1\WebForm1.aspx.vb Line: 50

Stack Trace:


[MySqlException: Character set 'cp1250' is not supported]
MySql.Data.MySqlClient.CharSetMap.GetEncoding(DBVersion version, String CharSetName)
MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)
MySql.Data.MySqlClient.NativeDriver.Configure(MySqlConnection connection)
MySql.Data.MySqlClient.MySqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
WebApplication1.WebForm1.btn2_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication1\WebForm1.aspx.vb:50
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()


I'm very new to MySQL and have no idea what to do about this problem, so any help would be realy appreciated.