dotConnect for MySQL Documentation
Charset Property
See Also  Send comments on this topic.
Devart.Data.MySql Namespace > MySqlConnection Class : Charset Property

Gets or sets charset that will be used on the client side.


Visual Basic (Declaration) 
Public Property Charset As String
public string Charset {get; set;}

Property Value

String that represents charset supported by MySQL server.


Use the Charset property to set a character set used by the client. Actually, if this property is enabled, then the "SET NAMES <Charset>" query is executed on establishing a connection.

By default the Charset property is empty. That means there is no action performed with charset on the client and on the server. You can set the Charset property value to 'auto'. In this case, the server asks for the charset and sets the appropriate charset on the client.

Note: You also can use the Unicode property to transfer all data to the UTF8 charset, but it may significantly reduce network traffic and thus decrease the application performance. If the Use Unicode property is set, the Charset property will be ignored.


Platforms:Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family, Windows 7, Windows 8, Windows 10, Windows Server 2012 family.

See Also