I suspect this isn't a DBI problem, but I also find this group has a
really good grasp on databases in general, so here goes.
I'm doing a select on a table (Oracle 8) that contains a Swedish name,
S�REN, and when I get it back, the second character is returned as a
question mark. Same thing happens when I use sqlplus, so that's why I
think it is not necessarily a DBI problem. I'd like to turn around and
use that name in additional sql statements, but obviously that doesn't
work.
I've found the NLS_LANG environment variable, but I have no idea what to
set it to. Or how. Setting it via a alter session set nsl_lang =
american_america.uS7ASCII, for example results in an error message,
ERROR at line 1:
ORA-00922: missing or invalid option
So, what do I need to do to get the right character set defined (for
lack of a better word).
Thanks,
Jim.
