Professional Web Applications Themes

Restoring table with \' in field - MySQL

Hi, When Administrator does backup it replaces a vlue like Jared's Data to Jared\'s Data. I then find myself manually changing \' to '' in notepad to allow restore to work. Has any body got any details on the escape sequence on windows, like a setting or control panel setting. I am using all the latest versions and fear that is half my problem....

  1. #1

    Default Restoring table with \' in field

    Hi,

    When Administrator does backup it replaces a vlue like Jared's Data to
    Jared\'s Data.

    I then find myself manually changing \' to '' in notepad to allow restore to
    work.

    Has any body got any details on the escape sequence on windows, like a
    setting or control panel setting.

    I am using all the latest versions and fear that is half my problem.


    Jared Guest

  2. #2

    Default Re: Restoring table with \' in field


    Jared wrote:
    > Hi,
    >
    > When Administrator does backup it replaces a vlue like Jared's Data to
    > Jared\'s Data.
    >
    > I then find myself manually changing \' to '' in notepad to allow restore to
    > work.
    >
    > Has any body got any details on the escape sequence on windows, like a
    > setting or control panel setting.
    >
    > I am using all the latest versions and fear that is half my problem.
    I make sure there aren't any extra slashes.
    After posting it, i use Rawpost( $_POST['field'] )

    function RawPost( $string ){
    if ( get_magic_quotes_gpc() ) $string = stripslashes( $string );
    return $string;
    };

    frizzle Guest

  3. #3

    Default Re: Restoring table with \' in field

    Looked into further is a bug with MySQL Query Browser 1.1.20



    Jared Guest

Similar Threads

  1. Binding form field to table field.
    By Bill in forum Microsoft Access
    Replies: 2
    Last Post: January 9th, 11:41 AM
  2. modify a field in all records of a table
    By Josselin in forum MySQL
    Replies: 1
    Last Post: May 4th, 06:11 AM
  3. sql query returned a to table in a field
    By Gm3512 in forum Dreamweaver AppDev
    Replies: 0
    Last Post: May 1st, 11:14 PM
  4. Select from table where field = string
    By Michel in forum PHP Development
    Replies: 6
    Last Post: August 24th, 06:35 PM
  5. Replies: 3
    Last Post: July 14th, 11:50 AM

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