Strategy One

Use Column Type Hint for Parameterized Query

Use Column Type Hint for Parameterized Query is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

The Use Column Type Hint for Parameterized Query VLDB property determines whether the WCHAR data type is used when applicable to return data accurately while using parameterized queries. This VLDB property has the following options:

  • Disabled (default): This option is recommended unless you are encountering the data inconsistencies described below.
  • Enable ODBC Column Type Binding Hint for "WCHAR" and "CHAR": This option should be used only if you have enabled parameterized queries in MicroStrategy for your database and data is not being correctly displayed on reports. This can include viewing question marks in place of other valid characters. This can occur for Netezza databases.

By selecting this option, the WCHAR data type is used when applicable so that the data is returned correctly while using parameterized queries.

Levels at Which You Can Set This

Database instance only