Unicode disabled

The 'UnicodeDisabled' extended property in the Object Type Customizer can be used to exclude individual object type attributes (i.e. a database table columns) from conversion to Unicode.

The need to exclude a column from conversion to Unicode may arise due to the 900 bytes limit on the total length of index columns on the MS SQL Server. An indexed column which could reach the limit but whose data never use special characters can be excluded.

To exclude a column from conversion to unicode:

1. In Valuemation Rich Client, open the Object Type Customizer, locate the object type in question and open it for editing.
2. Switch to the attributes tab. In its 'Used Attributes' section, select the attribute to be excluded from conversion to Unicode.
3. With the attribute selected, click the 'Edit Extended Properties' button (1). The 'Extended properties' dialog (2) opens.
4. Click the 'Add' button (3). A new 'Extended property' dialog opens (4).
5. In the 'Extended property' dialog, specify
   • Name: UnicodeDisabled
   • Value: true

   and click 'OK'.

   The 'UnicodeDisabled' extended property is added to the attribute and the attribute will be excluded from conversion to Unicode when it is performed.