_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