//http://dev.mysql.com/doc/refman/5.0/en/charset-mysql.html public MySqlCharacterSetSchemaCollection GetCharacterSets() { MySqlCharacterSetSchemaCollection characterSets = new MySqlCharacterSetSchemaCollection(); using (IPooledDbConnection conn = connectionPool.Request()) { using (IDbCommand command = conn.CreateCommand("SHOW CHARACTER SET;")) { try { using (IDataReader r = command.ExecuteReader()) { while (r.Read()) { MySqlCharacterSetSchema charset = new MySqlCharacterSetSchema(this); charset.Name = r.GetString(0); charset.Comment = r.GetString(1); charset.DefaultCollactionName = r.GetString(2); charset.MaxLength = r.GetInt32(3); characterSets.Add(charset); } r.Close(); } } catch (Exception e) { QueryService.RaiseException(e); } finally { conn.Release(); } } } return(characterSets); }
public void Initialize(MySqlSchemaProvider provider) { ClearCombos(); MySqlCharacterSetSchemaCollection charsets = provider.GetCharacterSets(); MySqlCollationSchemaCollection collations = provider.GetCollations(); foreach (MySqlCharacterSetSchema charset in charsets) { storeCharset.AppendValues(charset.Name, charset); } foreach (MySqlCollationSchema collation in collations) { storeCollation.AppendValues(collation.Name, collation); } }
public MySqlCharacterSetSchemaCollection(MySqlCharacterSetSchemaCollection collection) : base(collection, true) { }