inserting hebrew in access db with asp causes ???

I am inserting text into an access db

The english goes in fine but hebrew goes into the db as ??????

I know I have run into this before but I cannot remember the solution.

I have the <%session.CodePage = 1255%>
and
<meta http-equiv="Content-Type" content="text/html; charset=windows-1255">

anyone has any ideas?

is it showing up as ??? in access or when you try to recall it from the db onto a webpage. I'm no access expert but it may be that access just doesnt know how to display the characters its been given.

i think it's a probelm going into access.

I have had access in the past display it correctly but I can't seem to figure out now what the issue is.

Is it possible that you need to have the Hebrew language pack installed for Office products?

i don't think so as I have another db on teh server that is working.
I can't figure out what the difference is.

have you tried outputting the data to a webpage? Does it display correctly or does it display as ????

as ????

Not sure if this will help, but you might want to check it out. At the bottom of the page it talks about the different languages.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/achowSettingOptionsFromVisualBasic.asp