To Insert Bullets in a text field

[hemanr]

Gurus,

I have to insert text into a field. This text contains Bullets.
The insert goes through but when I query the table, Question marks(?) appear in place of the bullets.

How do I handle this?

Thanks!

[stecal]

What ascii character is your bullet? ASCII characters can go into your table with no problem.

SQL> create table supp (
2 col1 varchar2(10));

Table created.

SQL> insert into supp values ('* word');

1 row created.

SQL> select * from supp;

COL1
----------
* word

SQL> insert into supp values (chr(38)||' new');

1 row created.

SQL> select * from supp;

COL1
----------
* word
& new

Some characters are unrecognized -

127 -- 
128 --
129 --

130 -- 
131 -- 
132 -- 
133 -- 
134 -- 
135 -- 
136 -- 
137 --
138 --