Insertion of a special Character into a table
577414May 14 2007 — edited May 14 2007Hi all,
I came across a non keyboard character in an Oracle table (9i) and when i queried the table column with the following query
Code:
SELECT asciistr(col1) from test1;
I got the output as
\FFFD
\02DC
How could i insert the same character in my Oracle environment using the ascii code of the characters viz., \FFFD , \02DC
I tried inserting with the followin insert query,
INSERT INTO TEST1 VALUES ('\FFFD');
INSERT INTO TEST1 VALUES ('\\02DC');
but it inserted the above ascii codes as a character string rather than the special character.
Kindly advice on how to insert the special character using their ascii codes.
Please note that my Oracle version is 9i and its character set is WE8ISO8859P1.