dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlConnection Class / Charset Property

Charset Property (MySqlConnection)
Gets or sets charset that will be used on the client side.
Syntax
'Declaration
 
Public Property Charset As String
 

Property Value

String that represents charset supported by MySQL server.
Remarks
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 client asks the server for the charset and sets the appropriate charset.

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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also