Professional Web Applications Themes

cf structure and unicode data - Coldfusion - Advanced Techniques

Hello, Has anyone tried storing unicode characters in a cf structure? I have a structure in which I'm trying to store Japanese unicode characters and always get ??? when I dump the values. I can't seem to find a cht property or anything. Is this just a limitation of structures? Any help would be appreciated! Thanks, Amy...

  1. #1

    Default cf structure and unicode data

    Hello,

    Has anyone tried storing unicode characters in a cf structure? I have a
    structure in which I'm trying to store Japanese unicode characters and always
    get ??? when I dump the values. I can't seem to find a cht property or
    anything. Is this just a limitation of structures? Any help would be
    appreciated!

    Thanks,
    Amy

    shoalwater Guest

  2. #2

    Default Re: cf structure and unicode data

    i do that all the time. what version of cf? how is the data getting into the structs? i imagine that data might already be corrupted if its showing up as ??.

    PaulH Guest

  3. #3

    Default Re: cf structure and unicode data

    Ah! You are right it does work. I couldn't tell because the struct is
    created, then next page loads the struct with ??? where the double byte chars
    should be. Since I'm not bashing on the struct anymore, I have found the
    likely cause of the problem. The struct is serialized and stored in the client
    scope which is written to a sql server database (not unicode) and deserialized
    (sans my unicode characters) and loaded on the following page. I've updated
    the datatype for the field that stores unicode chars, now I just have to figure
    out how to get ColdFusion to use n'' notation when inserting client variables
    to the database, so the characters aren't lost.

    Thanks for getting me unstuck. I couldn't see past the structure...


    shoalwater Guest

  4. #4

    Default Re: cf structure and unicode data

    i imagine you'll have to do the client thing on your own. i don't recall seeing
    any way to modify cf's client sql (but i'll look around). i would also suggest
    that perhaps using a lot of client vars might not be such a good practice.

    PaulH Guest

Similar Threads

  1. DBI/DBD::Ingres and unicode data types
    By Dennis Roesler in forum PERL Modules
    Replies: 0
    Last Post: March 2nd, 04:22 PM
  2. Unicode Data and Database
    By Yadish in forum Coldfusion Database Access
    Replies: 5
    Last Post: August 15th, 10:24 AM
  3. Exporting to Excel with Unicode data
    By Bernard O'Flynn in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: August 11th, 04:16 PM
  4. what is this data structure?
    By Jack Chen in forum PERL Beginners
    Replies: 10
    Last Post: February 6th, 05:54 AM
  5. data structure help
    By James E Keenan in forum PERL Miscellaneous
    Replies: 0
    Last Post: August 9th, 06:47 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