ASP - Insert French Character in Access Database

Question

I want to insert french characters in an Access database using ASP.
Can you please suggest me what can i do??

Many Thanks
Shaheen

Answer 1

Here is half the answer

If you know the ASCII code of the french character then you can use the chr() function e.g.

INSERT INTO TestTable ( Field1 ) VALUES ( Chr(133));

Here is a list of relevant ascii codes french characters

[EDIT] A rather more complete example below

Sub Test_ASCII()
    Dim strSQL As String, strName As String
    strName = "Andr" & Chr(133) 'Good French Name
    strSQL = "INSERT INTO TestTable ( Field1 ) VALUES ('" & strName & "');"
    DoCmd.RunSQL strSQL
End Sub

Query runs fine, but the French "e" is not displaying correctly. Probably my setup -- refer comment below

I only have access 2002, perhaps later version have support for UFT-8 or UNICODE?