Skip to main content
May 13, 2011
Question

Text box search - Chinese UTF-8 issue

  • May 13, 2011
  • 1 reply
  • 1435 views

Hello,

I have a text box that should accept Chinese characters.  My Oracle backend is set up for it, and I thought

Coldfusion was already UTF-8 compliant.  However, I cannot search on anything that isn't numeric or

English.  I thought I took care of the encoding issue.  Anyone have this problem or solved it?

Thanks!

    This topic has been closed for replies.

    1 reply

    Community Expert
    May 13, 2011

    ColdFusion does support UTF-8. But that doesn't mean it'll automatically assume everything is UTF-8 (nor would you want it to).

    When you post the form, is the form post UTF-8? If not, use the setEncoding function.

    http://mysecretbase.com/ColdFusion_and_Unicode.cfm

    Dave Watts, CTO, Fig Leaf Software

    http://www.figleaf.com/

    http://training.figleaf.com/

    Dave Watts, Eidolon LLC
    May 13, 2011

    I set up what I read in the link, but I am still not getting what I need.  When I do the search, I don't get the data back that I search for.  I get something that the database or browser thinks is similar, but still no go.

    I can search on everything but that.  Of course, I am doing a copy/paste, and not actually

    inputting with a Chinese keyboard.  I don't know if that makes a difference?

    Inspiring
    May 13, 2011

    On 5/13/2011 11:13 PM, edsarro1 said:

    I set up what I read in the link, but I am still not getting what I need.

    When I do the search, I don't get the data back that I search for. I get

    something that the database or browser thinks is similar, but still no go.

    how exactly are you searching? you're getting some data back? how exactly does

    that differ from what you expect? are you sure you're inputting UTF-8 encoded

    chinese text? not some codepage like big5, gb2312, gb18030 or whatever?

    finally exactly what kind of chinese are you dealing with?