Andy,
Let's first check if our assumptions are correct. Can you do a
"SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET';"
This will give us the characterset used to create the database.
Please let me know the version and platform of your database, also.
Then try with NLS_LANG set to "American_America.WE8MSWIN1252". Insert some
value. Select it back again. If it still doesn't work, let me know the hex
values of what you inserted and a SELECT DUMP(column_name, 16)
FROM your_table;
Please use short strings.
Thanks and best regards,
Mark
Andy Brick wrote:
> Setting NLS_LANG to WE8ISO8859P1 or WE8MSWIN1252 stops me establishing a
> connection - DBI reports a login failure.
>
> Setting NLS_LANG to ENGLISH.WE8MSWIN1252 allows a login but does not solve
> the character set issue.
>
> Help !!
>
> Regards
>
> Andy Brick
> [EMAIL PROTECTED]
--
Mark Vandenbroeck Mobile : +32-495-59.55.62
EMEA Support Information Systems Email : [EMAIL PROTECTED]
AIM : markvdb
