We are using:
NLS_CHARACTERSET WE8ISO8859P15,
NLS_NCHAR_CHARACTERSET UTF8
NLS_LANGUAGE AMERICAN
on 10.2.0.3.0 Oracle DB,
Does anyone know how to convert from diacritical (international)
characters to ascii in sql (view) as one of our legacy systems cannot
handle non-ascii characters?
I've tried
select name,
convert(name, 'US7ASCII', 'WE8ISO8859P15')
from UV_AD_IMAGENOW_BIODEMO
results:
SæBø,Håkon S?B?,H?kon
TIA