French characters in an Insert statement

[jimf]

Hi,


i'm trying to execute an insert statement from an ASP.Net form page such as:
insert into documents (Name,NameFrench,Message,MessageFrench) values('info','information','See details ','Voir l'affiche pour des détails');

I get an exception on the insert statement.

If I copy the statement directly into a test query in the database, I get the following error: Syntax error (missing operator) in query expression "Voir l'affiche .... "


The insert dies on the " l'affiche " word. I need the those french characters in the database as they are pulled from those fields and are required to be displayed with the proper accent characters.

Does anyone know of a way to escape the French special characters?

[ranman256]

You can't use single quotes to insert a word that has a single quote in the word.
surround it with double quotes.

[orange]

insert into documents
 (Name,NameFrench,Message,MessageFrench)  
values('info','information','See details ','Voir l''affiche pour des  détails')

You can double (use 2 quotes) to tell Access you want the quote as part of the data, not syntax to delimit a string.

[jimf]

Thanks Guys,
both solutionswill work fine.


This thread can be closed.