Search:     Advanced search

Oracle NLS_LANG Setting

Article ID: 302  |  Last updated: 31 Dec, 2014


Question marks are displayed when you query data that was just inserted.


Client applications are often in a different computer 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 TestTrack Server with a value of AMERICAN_AMERICA.WE8MSWIN1252 then restart the server.

Article ID: 302  |   Last updated: 31 Dec, 2014
question mark Oracle query NLS_LANG

Prev   Next
Popup Blockers and TestTrack Web     Removing index.html from the TestTrack Web URL