NLS_CHARACTERSET

Had some issues displaying some XML data that I parsed into a table. Originally, I thought it was due to the data being imported correctly.

In the end however, i'm thinking its actually the charset setup, or lack thereof when using Oracle Instant client.

After setting the NLS_LANG environmental variable to match the database (in this case WE8MSWIN1252) the data displayed correctly in my query results.

SELECT a.VALUE FROM nls_database_parameters a
where a.PARAMETER = 'NLS_CHARACTERSET'