Hi, everyone.
Thanks for all the replies. I found that
setenv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
is what worked for me.
Thanks to all who helped,
Jim.
Jim Lynch wrote:
>
> 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.
snip