CODEWITHSUNDEEP
unicodeutf-8coldfusion
stubotnik
stubotnik

Reputation: 1982

Unicode characters in ColdFusion CLIENT scope

Is it possible to store unicode (utf-8) characters in ColdFusion's CLIENT scope? (CF9)

If I set a CLIENT scope variable and dump it immediately, it looks fine. But on next page load (ie: when CLIENT scope read back from storage) I just see question marks for the unicode characters.

I'm using a database for persistence and the data column in the CDATA table has been set to ntext.

Looking directly in the database I can see that the records have not been written correctly (again, just question marks showing for unicode characters).

Upvotes: 4

Views: 332

Answers (1)

Leigh
Leigh

Reputation: 28873

(From the comments)

Have you checked/enabled the: String format --Enable High Ascii characters and Unicode ..." option in your client datasource?

From the docs:

Enable this option if your application uses Unicode data in DBMS-specific Unicode data types, such as National Character or nchar.

Upvotes: 1

Related Questions