Professional Web Applications Themes

Newbie: How to add Non-breaking Space in a database field? - MySQL

Hi, Can anybody tell me how to insert a Non-breaking Space (ASCII 160) in a field using SQL? I use SQL*Plus. Any comments would be appreciated. Thanks, Raj....

  1. #1

    Default Newbie: How to add Non-breaking Space in a database field?

    Hi,

    Can anybody tell me how to insert a Non-breaking Space (ASCII 160) in a
    field using SQL? I use SQL*Plus.

    Any comments would be appreciated.

    Thanks,

    Raj.

    flashguru_in@yahoo.com Guest

  2. #2

    Default Re: Newbie: How to add Non-breaking Space in a database field?


    <flashguru_in> a écrit dans le message de news: [email]1141659980.338283.149080u72g2000cwu.googlegroups. com[/email]...
    | Hi,
    |
    | Can anybody tell me how to insert a Non-breaking Space (ASCII 160) in a
    | field using SQL? I use SQL*Plus.
    |
    | Any comments would be appreciated.
    |
    | Thanks,
    |
    | Raj.
    |

    insert into t values (ascii(160));

    But SQL*Plus doesn't know it as "Non-breaking Space" it just knows it as ascii(160).

    Regards
    Michel Cadot


    Michel Cadot Guest

  3. #3

    Default Re: Newbie: How to add Non-breaking Space in a database field?

    Michel Cadot wrote:
    > insert into t values (ascii(160));
    >
    > But SQL*Plus doesn't know it as "Non-breaking Space" it just knows it as ascii(160).
    >
    > Regards
    > Michel Cadot
    I suppose some tools on one particular OS uses ascii(160)
    as non-breaking space. Whatever it may be; my spaces don't
    ever break :)

    --
    Regards,
    Frank van Bortel

    Top-posting is one way to shut me up...
    Frank van Bortel Guest

Similar Threads

  1. Help! newbie question-white space management
    By alex.g@virgin.net in forum Coldfusion - Getting Started
    Replies: 4
    Last Post: May 20th, 08:05 PM
  2. Field Name with a Space
    By Frank Farning in forum Macromedia ColdFusion
    Replies: 1
    Last Post: April 4th, 01:14 AM
  3. Replies: 2
    Last Post: September 16th, 10:30 AM
  4. Newbie question - where is my disk space gone.
    By Dr. David Kirkby in forum AIX
    Replies: 5
    Last Post: July 7th, 04:44 PM
  5. Newbie question - where has my disk space gone?
    By Dr. David Kirkby in forum AIX
    Replies: 5
    Last Post: July 7th, 08:55 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