NLS_LANG

I'm setting up Oracle libraries in a Windows Server box so two PHP web sites can access a remote Oracle 10g database. I've downloaded the Instant Client *.zip package and everything works fine so far, except for some charset issues (Spanish letters do not show properly). Setting NLS_LANG environmental variable seems to be the clue but I don't know which value I should use. Given that data is in Spanish I have three likely candidates:

SPANISH_SPAIN.WE8MSWIN1252 (the Windows codepage)
SPANISH_SPAIN.WE8ISO8859P1 (ISO-Latin-1, used in first site)
SPANISH_SPAIN.WE8ISO8859P15 (ISO-Latin-9, used in second site)

 From the "Oracle Database Globalization Support Guide" I understand that NLS_LANG makes Oracle perform a charset conversion. Since both sites use different charsets and I can convert in my PHP app when necessary, I think it'd be a good idea that Oracle does not make any conversion. But I don't know how to find out the charset that database tables are using natively. How could I find out? Does all this make any sense?

--

• http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
• Mi sitio sobre programación web: http://bits.demogracia.com
• Mi web de humor al baño María: http://www.demogracia.com --