problems encoding hebrew text from access 97

[rami1972]

Hello,

I've moved a web site that I've built from a server that uses CF 5 to a server
that uses CF MX.

As seen in the page - [url]http://www.yes-od.com/kesher.cfm[/url]
The static hebrew HTML text apears just fine, but the dynamic hebrew text from
the access 97 data base apears in "jibrish".

Can anyone have a look at tell me what can be done so that the site will look
as it should be?

Thankshttp://www.yes-od.com/kesher.cfm

[paulh]

what encoding did you use to enter the data in the first place? mx
defaults to utf-8. you might get lucky, try simply changing the access
driver to "access for unicode" & see what happens. you have to decide
what encoding to use, unicode (which i laways recommend) or a hebrew
codepage (provided that's what you used in the first place). decide that
first.

btw this has no effect in mx and is in fact misleading as an artifact
(if that's why it's there): <meta http-equiv="Content-Type"
content="text/html; charset=windows-1255"> the page is actually
rendered using utf-8.