Re: Update NCHAR

From: Rüdiger J. Schulz <johannes.schulz_at_web.de>
Date: 09 Nov 2001 11:24:10 +0200
Message-ID: <3bebaeca$1@netnews.web.de>

try this:
update po_header set tt = TRANSLATE('o1' USING NCHAR_CS); hth
Rüdiger J. Schulz

Oliver Wong <oliverwong_at_aforce.com> wrote:
>How can I update the NCHAR field?
>The tt is a NCHAR(10).
>
>
>SQL> update po_header set tt='ol';
>update po_header set tt='ol'
>*
>ERROR at line 1:
>ORA-12704: character set mismatch
>

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de

Received on Fri Nov 09 2001 - 03:24:10 CST