Re: problem with character set using 10g

R.S. wrote:

> from sqlplus try:
>
> insert into description(descid,desc) values (10,CHR(138) );
>
> sqlplus doesn't "understand" special characters. Try toad.
>
> cheers,
>
> Roelof Schierbeek; DBA

Hardly.

The problem here has nothing to do with SQL*Plus it has to do with using a reserved word for a column name.

SQL*Plus: Release 10.1.0.4.0 - Production on Sun May 1 10:43:56 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> create table description (

   2 descid NUMBER(3),
   3 desc VARCHAR2(10));
desc VARCHAR2(10))
*
ERROR at line 3:
ORA-00904: : invalid identifier

SQL> ed
Wrote file afiedt.buf

   1 create table description (
   2 descid NUMBER(3),
   3* descx VARCHAR2(10))
SQL> / Table created.

SQL> insert into description(descid,descx) values (10,CHR(138));

1 row created.

SQL> select * from description

   2 /

     DESCID DESCX
---------- ----------

         10 Š

SQL>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)