Pb encode
When I use this sql :
Code :
SELECT REGEXP_REPLACE('5 à7', '[[:alpha:]FROM dual
I get this error
ORA-00907: parenthèse de droite absente
When I use this sql :
Code :
SELECT REGEXP_REPLACE('5 éà7', '[[:alpha:]FROM dual
I get this character: 5 ¿
I would like to have 57 ...
what's the solution ?
with a database with this enode : FRENCH_FRANCE.WE8MSWIN1252, I don't have the problème
Thanks for your help.