Skip to content

config sqlsetnames

Jump to bottom Edit New page
Byrne edited this page Nov 1, 2010 · 1 revision

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

  • Categories: Appendix: Configuration Directives

  • Tags: config, Updated for MT5

  • Updated for MT5

Add a custom footer
Add a custom sidebar
Clone this wiki locally