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 MySqlCollationSchemaCollection GetCollations() { MySqlCharacterSetSchema sch = new MySqlCharacterSetSchema(this); sch.Name = ""; return(GetCollations(sch)); }
//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 MySqlCharacterSetSchema (MySqlCharacterSetSchema schema) : base (schema) { defaultCollactionName = schema.defaultCollactionName; defaultCollactionName = schema.defaultCollactionName; }
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 MySqlCollationSchemaCollection GetCollations () { MySqlCharacterSetSchema sch = new MySqlCharacterSetSchema (this); sch.Name = ""; return GetCollations (sch); }
//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 MySqlCharacterSetSchema(MySqlCharacterSetSchema schema) : base(schema) { defaultCollactionName = schema.defaultCollactionName; defaultCollactionName = schema.defaultCollactionName; }