RE: utf8

[Steve Main]

Title: Message

Thanks Ian,

 

Unfortunately I haven't been able to get this to work either....

 

Running the command below from a Windows sqlplus session

 

SQL> update product set name = chr(2122) where sku = 'IB1';

 

1 row updated.

 

SQL> commit;

 

Commit complete.

 

SQL> select dump(name) from product where sku = 'IB1';

 

DUMP(NAME)
--------------------------------------------------------------------------------
Typ=1 Len=2: 8,74

 

the windows NLS_LANG is set to AMERICAN_AMERICA.WE8MSWIN1252 which according to Metalink

correct......

-----Original Message-----
From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: utf8

How about

 

insert into  <TABLE_NAME> (<FIELD_NAME>)  values (CHR(2122));

 

Ian MacGregor

Stanford Linear Accelerator Center

[EMAIL PROTECTED]

-----Original Message-----
From: Steve Main [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L
Subject: utf8

Hello List,

 

I have built a database with a character set of UTF8 and I'm trying

to insert character code 2122 "(TM) Trademark".  I'm having

trouble coming up with a way to do this.....

 

anyone had to deal with this before?

 

Thanks

 

Steve