public MySqlCollationSchemaCollection GetCollations(MySqlCharacterSetSchema characterSet) { MySqlCollationSchemaCollection collations = new MySqlCollationSchemaCollection(); using (IPooledDbConnection conn = connectionPool.Request()) { using (IDbCommand command = conn.CreateCommand(String.Format("SHOW COLLATION LIKE '{0}%';", characterSet.Name))) { try { using (IDataReader r = command.ExecuteReader()) { while (r.Read()) { MySqlCollationSchema collation = new MySqlCollationSchema(this); collation.Name = r.GetString(0); collation.CharacterSetName = r.GetString(1); collation.Id = r.GetInt32(2); collation.IsDefaultCollation = r.GetString(3) == "Yes" ? true : false; collation.IsCompiled = r.GetString(4) == "Yes" ? true : false; collation.SortLength = r.GetInt32(5); collations.Add(collation); } r.Close(); } } catch (Exception e) { QueryService.RaiseException(e); } finally { conn.Release(); } } } return(collations); }
public MySqlCollationSchema (MySqlCollationSchema schema) : base (schema) { id = schema.id; isDefaultCollation = schema.isDefaultCollation; isCompiled = schema.isCompiled; sortLength = schema.sortLength; }
public MySqlCollationSchema(MySqlCollationSchema schema) : base(schema) { id = schema.id; isDefaultCollation = schema.isDefaultCollation; isCompiled = schema.isCompiled; sortLength = schema.sortLength; }
public MySqlCollationSchemaCollection GetCollations (MySqlCharacterSetSchema characterSet) { MySqlCollationSchemaCollection collations = new MySqlCollationSchemaCollection (); using (IPooledDbConnection conn = connectionPool.Request ()) { using (IDbCommand command = conn.CreateCommand (String.Format ("SHOW COLLATION LIKE '{0}%';", characterSet.Name))) { try { using (IDataReader r = command.ExecuteReader ()) { while (r.Read ()) { MySqlCollationSchema collation = new MySqlCollationSchema (this); collation.Name = r.GetString (0); collation.CharacterSetName = r.GetString (1); collation.Id = r.GetInt32 (2); collation.IsDefaultCollation = r.GetString (3) == "Yes" ? true : false; collation.IsCompiled = r.GetString (4) == "Yes" ? true : false; collation.SortLength = r.GetInt32 (5); collations.Add (collation); } r.Close (); } } catch (Exception e) { QueryService.RaiseException (e); } finally { conn.Release (); } } } return collations; }