Last post Oct 26, 2015 05:24 AM by PatriceSc
Oct 26, 2015 05:09 AM|ssjGanesh|LINK
I have receving this input C_CUENTA_COTIZACIÓN_SS_SMP and passing that into a stored procedure
but i have that value in my table like C_CUENTA_COTIZACION_SS_SMP.
when I am checking like both are equal or not it return false because of that special character (Ó).
IHow to make that valueable string and compare with my table data?
Oct 26, 2015 05:24 AM|PatriceSc|LINK
It seems your current value is accent sensitive. You could use an accent insentive value. See for example "Solution alternatives" case 2 about including the collate clause Inside the query.