Professional Web Applications Themes

Problem with "=" sign in varchar field - MySQL

I have a varchar field containing a string that is a mixture of letters and an "=" sign. This seems to be causing MySQL grief when I ask it what is in that field - is there any reason for this? Are there any characters it doesn't like to find hanging around in varchar fields? Cheers, Ben...

  1. #1

    Default Problem with "=" sign in varchar field

    I have a varchar field containing a string that is a mixture of letters
    and an "=" sign. This seems to be causing MySQL grief when I ask it
    what is in that field - is there any reason for this? Are there any
    characters it doesn't like to find hanging around in varchar fields?

    Cheers,

    Ben

    Ben Guest

  2. #2

    Default Re: Problem with "=" sign in varchar field

    To be a bit less vague:

    I have checked the string being sent to the varchar field. It is of the
    form:

    "foo=bar"

    There are no errors
    If I display the MySQL table in the command window without that field
    displayed, everything is fine
    If however I try to display it the table formatting goes haywire,
    column boundries go all over the place, and the table becomes a mess.
    As far as I can tell though the data is still in there...

    Any thoughts?


    Ben wrote:
     

    Ben Guest

  3. #3

    Default Re: Problem with "=" sign in varchar field

    Ben wrote: 
    >
    >
    > To be a bit less vague:
    >
    > I have checked the string being sent to the varchar field. It is of the
    > form:
    >
    > "foo=bar"
    >
    > There are no errors
    > If I display the MySQL table in the command window without that field
    > displayed, everything is fine
    > If however I try to display it the table formatting goes haywire,
    > column boundries go all over the place, and the table becomes a mess.
    > As far as I can tell though the data is still in there...
    >
    > Any thoughts?
    >
    >
    > Ben wrote:
    >
    >[/ref]
    (Top posting fixed)

    MySQL doesn't care about the '=' sign. MySQL also doesn't display
    (other than the command line version).

    What are you trying to display it with?

    P.S. Please don't top post. Thanks.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  4. #4

    Default Re: Problem with "=" sign in varchar field


    Jerry Stuckle wrote:
     
    > >
    > >
    > > To be a bit less vague:
    > >
    > > I have checked the string being sent to the varchar field. It is of the
    > > form:
    > >
    > > "foo=bar"
    > >
    > > There are no errors
    > > If I display the MySQL table in the command window without that field
    > > displayed, everything is fine
    > > If however I try to display it the table formatting goes haywire,
    > > column boundries go all over the place, and the table becomes a mess.
    > > As far as I can tell though the data is still in there...
    > >
    > > Any thoughts?
    > >
    > >
    > > Ben wrote:
    > >
    > >[/ref]
    > (Top posting fixed)
    >
    > MySQL doesn't care about the '=' sign. MySQL also doesn't display
    > (other than the command line version).
    >
    > What are you trying to display it with?
    >
    > P.S. Please don't top post. Thanks.
    >
    > --
    > ==================
    > Remove the "x" from my email address
    > Jerry Stuckle
    > JDS Computer Training Corp.
    > net
    > ==================[/ref]

    I am using the command line version to display :-) (v 5.0.21) I am
    going to try settin up a frontend to see what that shows me...

    Cheers,

    Ben

    Ben Guest

Similar Threads

  1. "Page" and "Rect" props of the Field prop in Javascript API
    By ArtIn_Act@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 8
    Last Post: March 19th, 05:35 PM
  2. Replies: 2
    Last Post: September 15th, 04:35 AM
  3. "&" sign problem
    By Greg Zwierzynski in forum ASP
    Replies: 2
    Last Post: July 25th, 03:26 PM
  4. dr("field").toString returns "400.0000" instead of "400"
    By Dan C Douglas in forum ASP.NET General
    Replies: 5
    Last Post: July 22nd, 05:48 PM
  5. dr("field").toString returns "400.0000" instead of "400"
    By Dan in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: July 22nd, 05:48 PM

Bookmarks

Posting Permissions

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