WString support

WSTRING is available for using the Unicode character set.

This data type must be activated in the server settings so that it can be written to the database using the TwinCAT Database Server in PLC Expert mode.

WString support 1:

This data type requires two bytes per character. Please keep this in mind when creating the table structure. To be able to save it in the database in UTF16 format, the column must be created according to the character set. The SQL Query Editor can also be used for this purpose.

WString support 2:

The following databases are supported with the Database Server:

Database

UTF8

UTF16

Character set definition

Performance impairment

MySQL

x

x

column-specific

x

MSSQL

x

x

column-specific

 

Oracle

x

x

column-specific

 

PostgreSQL

x

x

cross-database

x

Others

x

 

 

 

WString support 3:

Performance impairment

Some databases cause performance problems, because additional SQL commands have to be sent in order to read the character set.

WString support is available from version 3.1.31.4.