Search: Advanced search
Please enter a keyword or ID
Question Marks Displayed When Querying Helix ALM Oracle Databases
Question marks are displayed when you query data that was just inserted in a Helix ALM Oracle database.
Client applications are often in a different environment than the database server. In this case, the NLS_LANG setting of the client application may differ from the database character set and character set conversion is necessary.
When a target character set does not contain all characters in the source data, replacement characters such as the question mark, are used during conversion. The invalid characters in the target character set are all replaced with the question marks. Usually no error is returned when the replacement characters are used.
Create an NLS_LANG environment variable on the Helix ALM Server with a value of AMERICAN_AMERICA.WE8MSWIN1252 then restart the server.