It's all to do with your database character set and your national language
character set. Then it's a question of whether the column being inserted
into is defined as a CHAR or an NCHAR (or, I suppose, as a VARCHAR2 or an
NVARCHAR2). The N* versions of character data types allow you to store
characters in whatever was defined as your national language character set.
If you create your database using a unicode national character set, pretty
much any weird character can be inserted into any column defined as an N*
data type.
Regards
HJR
--
Resources for Oracle: http://www.hjrdba.com
===============================
"carol" <carol_cca_at_excite.ca> wrote in message
news:8aa38bb5.0111151132.56040540_at_posting.google.com...
> Hi,
>
> I could input a character with a little raised character at the right
> corner from the screen and save it in a text column in an oracle
> database. But when I query the data, I found that actually the raised
> character was saved as question mark. Does anyone know how I can save
> the special character? Or I have to save it as a image?
>
> My oracle version is 8.1.7.
Received on Thu Nov 15 2001 - 14:31:13 CST
