Home > comp > gb.db.mysql > _database > modify 
  [3.0]
 fr de es it nl pl pt pt_BR mk sq ca ar fa vi ja ru zh zh_TW eo
Previous  Next  Edit  Rename  Undo  Refresh  Search  Administration  
Documentation
History
 
Modify
Alters a database.

Database: Is the name of the database to use. If isn't given, then the current database is used.
Charset: Is the charset to use.
Collation Is the collation to use.

If Charset and Collation are not provided, then the default ones are used.

Examples

Dim hCon As New Connection

With hCon
  .Type = "mysql"
  .Port = "3306"
  .Host = "localhost"
  .User = "root"
  .Password = "mypass"
  .Name = "Gambas"
  .Open()
End With

hCon.MySQL.DataBase.Modify("Gambas", hCon.MySQL.Charset, hCon.MySQL.Collation)

MySQL statement: ALTER DATABASE `Gambas` DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE utf8_general_ci