Re: VARCHAR(None, CHAR)

  • From: Jose Soares <jose.soares@xxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 22 Nov 2013 16:57:30 +0100

You are right, Hans.
That's a sqlalchemy bug.

Here the sqlalchemy author reply:
"seems like even in master it’s still doing that so this is a new issue http://www.sqlalchemy.org/trac/ticket/2870. 
give it a length for now.
cast(x, String(100))"


j


On 11/22/2013 04:18 PM, Hans Forbrich wrote:

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
--
//www.freelists.org/webpage/oracle-l




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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2013