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