cf structure and unicode data

[shoalwater]

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 charset property or
anything. Is this just a limitation of structures? Any help would be
appreciated!

Thanks,
Amy

[PaulH]

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

[shoalwater]

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

[PaulH]

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.