_MySQL.Collation (gb.mysql)
Property Collation As String
Returns or sets the Collation used by the MySQL class.
The default Collation is utf8_general_ci
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.Collation = "utf8_general_ci"
Print hCon.MySQL.Collation
See your information_schema.COLLATIONS for all aviable collation.
Charset & Collations for more details.