PH40495: COGNOS SQL APPENDS A CHARACTER "N" FOR EACH FILTER QUERY WHEN DATABASE COLLATION IS SET TO HEBREW_100_CS_AI_SC_UTF8

APAR status

• Closed as Permanent restriction.

Error description

• When the collation sequence for a Reporting Database is set to
  'Hebrew_100_CS_AI_SC_UTF8'  we find that each query with a
  filter sent from Cognos to the reporting database has "N"
  character for each filter.
  The DB collation is UTF-8 though the DB tables are not
  configured as Unicode. The problem is reproducible when the
  Tables from the reporting database are imported in Framework
  Manager and the tables are updated using the 'Update Object'
  found under FM tools
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * n/a                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See above                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Customer facing statement:
  
  First, where the original data type of a column imported from a
  database is CHAR, the data type of the column becomes NCHAR due
  to the UTF8 character set in the collation
  Hebrew_100_CS_AI_SC_UTF8 when updating the query subject.
  
  Second, when the model contains an NCHAR data type, then we
  generate the prefix 'N' in the WHERE clause. (In the planning,
  we add the prefix ?N? to a literal when comparing the literal
  with the NCHAR column - for example, select * from T where
  NCHAR_COL = N?abc?.)  When using NCHAR data types, the data will
  be retrieved from SQL Server directly as unicode. The observed
  behavior is expected when using any UTF8 character set.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels