Re: problem with character set using 10g

From: R.S. <bytelife_at_gmail.com>
Date: Sun, 1 May 2005 13:01:43 +0200
Message-ID: <4274b717$0$29053$dbd4f001@news.wanadoo.nl>

from sqlplus try:

insert into description(descid,desc) values (10,CHR(138) );

sqlplus doesn't "understand" special characters. Try toad.

cheers,

Roelof Schierbeek; DBA

"tri dhungana via DBMonster.com" <forum_at_nospam.DBMonster.com> schreef
> hi i have install oracle 10g Enterprise Edition in win xp. Now i want to
> insert some character like (alt + 0138 i.e S)in the table only. The font
> used is Type New Roman
> my sql command is:
>
> insert into description(descid,desc) values (10,S)
>
> it inserts the value all right but when i see the values using select
> statement it displays some other character.Some other character also shows
> same problem. I want to display S as it is. Could some one help me???????
Received on Sun May 01 2005 - 06:01:43 CDT