Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Cast from varchar2 to nvarchar2

Cast from varchar2 to nvarchar2

From: <vyacheslav.vasylyev_at_gmail.com>
Date: Mon, 04 Jun 2007 20:46:39 -0000
Message-ID: <1180989999.972677.208550@q66g2000hsg.googlegroups.com> 





I'm having a problem casting a column. I have something like this:



SELECT CAST(column1 AS nvarchar2(20)) FROM Table1



column1 is of type varchar2(20). Also, cannot cast numeric values to
nvarchar2. I'm running Oracle 8i.


Is this type of cast illegal? Is there any way to cast to nvarchar2?
Any help would be appreciated.


Thanks in advance.
Received on Mon Jun 04 2007 - 15:46:39 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US