I have to use an old charset WE8ISO8859P1 (it a working environment, not sure why but I cannot change this) so I had to change my variable to NVARCHAR2. Only problem when I try to filter based on the eur symbol € it will not return anything, while before the filter was working in my select but using varchar2 it will display as ¿
I want to be able to insert the € in my oracle db and be able to do a
select * from mytable where myvariable='€';
Is that even possible without changing the charset?