I am using Spanish characters in my application. Currently I am storing Spanish accents like this in to database
é í ó útestestet
If I am using query from database like this
UPDATE indi_cmi_unidad
SET
nombre='Oscar:Oscar: Oscar: é í ó ú',
factor='0',
indi_unidad_base='',
abreviatura='tc'
WHERE idunidad='3'
Then it is Okey it will save this characters
But when I am passing this query from ADODB + PHP, then it is reflecting special character in database like,
I tried a lot I also put this query in my constructor class of adodb
$sql = "ALTER SESSION SET NSL_CHARACTERSET = 'US7ASCII'";
But not getting any result. Please help me
Thanks & Regards