SQLSetNames
This configuration directive specifies the character encodings used by the DBMS client when using MySQL and PostgreSQL. This directive is needed by individuals using character codes incompatible with Latin-1.
Values ¶
- 0 (default)
- 1
If the directive was set(1), MT Object Drivers send SET NAMES command to DBMS before any query is sent. The parameter to SET NAMES sql statement (the name of character encoding) is pulled from PublishCharset. The SET NAMES call tells DBMS which client side character encoding to be used.
By default, MT will check to see if this value is necessary and automatically set a value.
Example ¶
To enable
SQLSetNames 1
Note: When upgrading from older versions with MySQL 5.x and UTF-8, specify false:
SQLSetNames 0
Leave a note
Have a question? Please use the MT Forums. Notes submitted on documentation should pertain to tips & hints regarding documentation. Your note may be removed once its contents have been integrated into the body of the page.