Migrating from CF5 to CF7

[ZOD_Nir]

I tried to migrate a site which was working on a server with CF5 to a server
with CF7.
Everything worked fine - but all the text which comes from the DB displays as
jibrish instead of Hebrew.
Connection to the mySQL server is through ODBC.
The encoding in mySQL is: ISO-8859-8 (worked very fine with CF5)

What is the solution?
Is it something to include in the code or is it some settings that needs to be
changed ?

The url for the site on the new server:
[url]http://d160738.si40.siteam.co.il/index.cfm[/url]


Thanks,

Nir

[tzimmerman]

See [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19217[/url].

Ted Zimmerman

[ZOD_Nir]

Thanks for this TechNote url -

"...To work around this problem, retrieve the data from the database using a
ColdFusion 5 installation, and reinsert it using ColdFusion MX. This
reinsertion of the data with ColdFusion MX will cause the data to be stored in
standard Unicode format, so that no further conversion should be necessary."

Any idea how to implement this solution?
In my case the servers are located in different locations.