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> a écrit dans le message de news: 1141659980.338283.149080@u72g2000cwu.googlegroups. com...
| 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 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...