Professional Web Applications Themes

Migrating from CF5 to CF7 - Coldfusion Database Access

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...

  1. #1

    Default Migrating from CF5 to CF7

    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


    ZOD_Nir Guest

  2. #2

    Default Re: Migrating from CF5 to CF7

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

    Ted Zimmerman
    tzimmerman Guest

  3. #3

    Default Re: Migrating from CF5 to CF7

    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.


    ZOD_Nir Guest

Similar Threads

  1. Migrating from flex 1.5 to 2.0
    By shilpi_jain in forum Macromedia Flex General Discussion
    Replies: 6
    Last Post: June 21st, 05:25 PM
  2. Migrating to new server
    By Bugsville in forum Coldfusion Server Administration
    Replies: 3
    Last Post: September 9th, 09:08 PM
  3. migrating from mysql
    By Junaili Lie in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: December 23rd, 01:18 AM
  4. Migrating to PHP 5
    By EniGMistA in forum PHP Development
    Replies: 2
    Last Post: July 28th, 01:48 PM
  5. Replies: 5
    Last Post: June 24th, 04:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139