1. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Mar 2003
    Rep Power

    Character sets, ColdFusion, and MySQL

    I had a problem with character sets when using ColdFusion and MySQL. We found a solution, so I figured I'd post it here so everyone knows.

    ColdFusion MX by default uses UTF-8 for it's charater encoding. This is not supported by MySQL before version 4.1. This does not mean you can't store it in MySQL. What you have to do is take the string and encode it in Base64 using the ToBase64 function. You then store it in a text field. When you retrieve it, you have to convert it to binary, then convert it to a string using the ToBinary and ToString functions.

    The only issue that we came across was that the Base64 encoding makes the string longer, so if you're having trouble, double check your field lengths. I don't know how much longer it makes strings.

    Hope this helps.
    Gratuitously stolen...
    mysql> SELECT * FROM user WHERE clue > 0;
    0 Results Returned.

    My Tech Blog
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    MOV @R1, P1 ; RAM (40H) <= OCAH
    Rep Power
    BTW, just to add something here, with you hv cfmx 6.1 and access to the administrator, you can change the default charset encoding
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Rep Power
    I changed my charset encoding in cfmx 6.1 but now it changes hyphen, apastraphe and a few more characters include three dots "..." to "?". Any idea how i can fix that. for the time being i am formatting my strings to use the HTML character code instead of the symbolds themselves...hope some one has an idea about this.

IMN logo majestic logo threadwatch logo seochat tools logo