_DataBase.Modify (gb.mysql)

Sub Modify ( [ Database As String, Charset As String, Collation As String ] )

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