Skip to main content
A
Anonymous
April 15, 2009
Question

UTF issue when moving from cf5 to cfmx7

  • April 15, 2009
  • 1 reply
  • 1019 views

It's been long overdue so am moving from CF5 to cfmx7 on my hosting account.

The issue is that my hosting account has disabled cfcontent.

I am getting gibberish outputting utf data from my database. It works fine on cf5 but on cfmx7 I read someplace that you have to use cfcontent to output utf-8 correctly.

Is there any work around without having to use cfcontent?

I tried using cfprocessingdirective and cfheader tags to show utf but it didn't work. Any pointers or suggestions appreciated.

Best Regards

Sanman

    This topic has been closed for replies.

    1 reply

    T
    tooMuchTrouble
    Inspiring
    April 15, 2009

    ..geez i wish i could quote via email...

    first off it's more than likely your utf-8 data is trashed as far as the rest of

    the world is concerned, since cf5 didn't know encoding from a hole in the

    ground. you'll probably need to re-insert your data via cf8 & have it properly

    encoded. you can do this via cfhttp calls from the cf8 server to the cf5 server

    against cf pages that simply dump out the data in a form that you can parse out

    & re-insert in your db. at least that's how i (and a few others who got caught

    looking) did it.

    what's the db?

    A
    Anonymous
    April 15, 2009

    The db is mssql2000. Currently when i run queries on the data, it outputs the data correctly in UTF in CF5.

    It's outputting gibberish when I output the query on ths same data on cfmx7.

    T
    tooMuchTrouble
    Inspiring
    April 15, 2009

    that it works in cf5 isn't surprising, that's what mangled & inserted the data.

    how is the data stored, ie what datatype? is it one of the "N" types?

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices