Firebird Server Version: WI-V2.5.0.26074 Firebird 2.5
CREATE DATABASE 'bdname' DEFAULT CHARACTER SET WIN1251;
create procedure test (p_in varchar(256))
returns (p_out varchar(256))
as
begin
rdb$set_context('USER_SESSION', 'UNAME', :p_in);
p_out = coalesce(rdb$get_context('USER_SESSION', 'UNAME'), current_user);
suspend;
end
isql -u sysdba
execute procedure test('test')
--test
execute procedure test('ÔÅÓÔ') --ÎÅ ÌÁÔÉÎÉÃÁ
Invalid token
Mailformed string
At procedure TEST1 line 7 col 2
âÁÇÁ ÉÌÉ ËÁËÉÅ-ÔÏ ÚÁÍÏÒÏÞËÉ Ó ËÏÄÉÒÏ×ËÁÍÉ?
ëÓÔÁÔÉ, ÅÓÌÉ ÚÁÍÅÎÉÔØ ÎÁ
p_out = coalesce(rdb$get_context('USER_SESSION', 'UNAME'),
rdb$get_context('SYSTEM', 'CURRENT_USER'));
ÔÏ ×ÓÅ ÎÏÒÍÁÌØÎÏ.