I wanted to ask how the 'DEFAULT' keyword affects the length of variable declared in stored procedue. Here is a sample code:
REPLACE PROCEDURE database.stored_procedure()MAIN:BEGIN /* Declare variables */ DECLARE vVar1 VARCHAR(32000) CHARACTER SET UNICODE DEFAULT 'abc';END MAIN;
My question here is that will using the DEFAULT keyword, in any way, effect the length of variable vVar1?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.