Re: Update NCHAR

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 09 Nov 2001 12:59:53 +0100
Message-ID: <u8hnutcq8nb4q2n7g87n3dvntdtrdaht0j@4ax.com>

On Fri, 09 Nov 2001 15:56:59 +0800, 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

update po_header
set tt=N'ol'
/

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Nov 09 2001 - 05:59:53 CST