Re: VARCHAR(None, CHAR)

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Fri, 22 Nov 2013 08:18:42 -0700
Message-ID: <528F75D2.9040208_at_gmail.com>

On 22/11/2013 2:41 AM, Jose Soares wrote:

>

> I can't understand the syntax: VARCHAR(None CHAR). I suppose the error
> is generated by it. Isn't it?

Perhaps "CAST ( field AS VARCHAR2 ( length CHAR | BYTE ) )"

in which the 'None' is being interpreted as 'length' ... CHAR allows multi-byte chars

http://docs.oracle.com/cd/E16655_01/server.121/e17209/functions023.htm#SQLRF51260 http://docs.oracle.com/cd/E16655_01/server.121/e17209/sql_elements001.htm#SQLRF50977

/Hans

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 22 2013 - 16:18:42 CET