Oracle : quoted strings with accents??

admin

Administrator
Staff member
Hi,

I don't understand why oracle tells me this...

OCIParse: ORA-01756: quoted string not properly terminated

... When I try to insert a string with simple quote in this kind...

'bonjour, je m\'appelle Nicolas'

... And why doesn't it keep accent in the database? Table fields are Varchar2(1024), and form fields are transmitted by post method...

Do I have to prepare my strings before put them into a SQL query with oracle?

thanks
 
Back
Top