Coldfusion Submission to MySQL DB "£" sign interpreted incorrectly?

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default Coldfusion Submission to MySQL DB "£" sign interpreted incorrectly?

    Hi,

    I have noticed that certain characters are not being submitted to my db
    correctly, I originally wrote a function to convert all of the coded
    characters back to their real life counter-parts however this will mean
    placing the function on every page that interacts with the db.

    i figure this is something to do with mysql not liking the "£" symbol, and
    jus thought there was something i might be able to do via coldfusion to
    remove this glitch?

    Many thanks,
    Moss


    Moss Guest

  2. Similar Questions and Discussions

    1. PDF displays "L" and rules incorrectly
      You may be suffering from a bug with the pdf library used with Acrobat6 and CS1 apps, where it treats i and l as lines. This is known to happen when...
    2. creating a "new user" submission form
      Hi I am trying to create a registration form for users to give me their info like name, username/password, billing address and shipping info. This...
    3. Including "less equal" sign in MX under windows
      How can I include special characters like the "less equal" character in a technical FreeHand MX drawing under Windows 2000? - Characters like...
    4. #12029 [Com]: "--with-apxs" can cause the error "MySQL: Unable to save result set in"
      ID: 12029 Comment by: sietzepost at streetwisedd dot nl Reported By: root at byone dot com Status: Bogus Bug...
    5. "&" sign problem
      HI , I am passing few parameters from one page to another. One of the parameters is order number. In one particular case the order number...
  3. #2

    Default Re: Coldfusion Submission to MySQL DB "?" signinterpreted incorrectly?

    what version of cf? if its mx, what driver are you using (JDBC or ODBC)? what encoding is your database? what endoing are your cf pages?

    PaulH Guest

Posting Permissions

  • You may not post new threads
  • You may 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