Bug #17748 There is no char type in MySqlDbType
Submitted: 27 Feb 2006 18:53 Modified: 28 Feb 2006 17:01
Reporter: Maksim Aliseenko Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:1.0.7 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[27 Feb 2006 18:53] Maksim Aliseenko
Description:
When I try to get MySqlCommandBuilder.DeriveParameters method with a procedure which have char type parameter, I throw MySqlException exception with message "Unhandled type encountered".

How to repeat:
following code
private void addPortalInfo_Click(object sender, System.EventArgs e)
		{
			MySqlConnection conn = new MySqlConnection("SERVER = Localhost;DATABASE = test;UID = root;PASSWORD =;");
			MySqlCommand cmd = new MySqlCommand("testProc", conn);
			cmd.CommandType = System.Data.CommandType.StoredProcedure;
			MySqlParameter[] discoveredParameters; 
			try
			{
				conn.Open();
				MySqlCommandBuilder.DeriveParameters(cmd);
				conn.Close();
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
			}
			discoveredParameters = new MySqlParameter[cmd.Parameters.Count - 1];
			cmd.Parameters.CopyTo(discoveredParameters, 0);
		}

testProc - stored procedure with char type parameter

Suggested fix:
Add char type in MySqlDbType
[27 Feb 2006 18:55] Maksim Aliseenko
Sorry! This bug for .Net Connector!
[28 Feb 2006 17:01] Hartmut Holzgraefe
duplicate of bug #17749