Re: VARCHAR(None, CHAR)

From: Jose Soares <jose.soares_at_sferacarta.com>
Date: Fri, 22 Nov 2013 16:57:30 +0100
Message-ID: <528F7EEA.5040109_at_sferacarta.com>

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

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

Received on Fri Nov 22 2013 - 16:57:30 CET