This is oracle 11g (both database and forms).
I've got a table with a blob column for a file and a varchar2 column for the filename.
I've got a form that retrieves the file to the client hdd and opens it. Till now it was working fine.
Today we've got an issue with a file unable to open. The problem is that the filename varchar2 has an odd character inside:
´
which is a chr(180)
The problem is that sqldeveloper shows the accent ok:
Pértigas-VAT´s.pdf
, but forms shows this:
Pértigas-VAT¿s.pdf
Why is forms getting it wrong?
My NLS_LANG is NLS_LANG=SPANISH_SPAIN.WE8MSWIN1252 in both database and windows client registry. (I still have to ask to the sysadmin if the weblogic is also this, but I think so).