I am using MaxDB 7.5 (_UNICODE = YES, DEFAULT_CODE = UNICODE) and there is a
very strange situation when i want to create dbproc accepting Unicode
parameters, a simple procedure as reflection does not work.
CREATE DBPROC REFL (IN Q VARCHAR(100), OUT R VARCHAR(100)) AS
R = Q;
If you call this with anything that is not Ascii (in my case Cyrilic) there
is an error:
Auto Commit: Off, SQL Mode: Internal, Isolation Level: Committed
Restricted data type attributes violation.
CALL RF ('????',:X)
How ever when i try to create the procedure as below there is an other
error.
CREATE DBPROC REFL (IN Q VARCHAR(100) UNICODE, OUT R VARCHAR(100) UNICODE)
AS
R = Q;
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Syntax error or access violation;-5015 POS(24) Missing
keyword:VARCHAR,REAL,NUMERIC,FLOAT,FIXED,DECIMAL,DEC,CHARACTE.
CREATE DBPROC RF (IN R VARCHAR (100), OUT R VARCHAR(100) UNICODE) AS
R = Q;
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
