Hi!
I'm having the following problem. I have writen an sp like the one
below in ibexpert and posted it to my database. As you can see, there
is information given about the charset of the string return values.
Now, after posting the procedure, closing the sp editor and reopening
it, all the information about the charset is gone. I'm having the
suspicion that this is the reason for a particular problem I'm having
while accessing the sp with my data components in delphi so does any
of you have an idea what to do against this mysterious disappearing of
the charset information?

Thanx,

Martin


CREATE PROCEDURE GET_NEXT_20_DICENTRIES_AB_DATUM (
DATUMINPUT DATE,
IDIN BIGINT)
RETURNS (
ZSDEF BLOB SUB_TYPE 1 SEGMENT SIZE 4096 CHARACTER SET UNICODE_FSS,
POS INTEGER,
ASABK VARCHAR(10) CHARACTER SET UNICODE_FSS,
ASPRGM VARCHAR(20) CHARACTER SET UNICODE_FSS,
ID BIGINT,
ASTERM VARCHAR(80) CHARACTER SET UNICODE_FSS,
ASAUDIO VARCHAR(20) CHARACTER SET UNICODE_FSS,
ASDSKRPT1 VARCHAR(15) CHARACTER SET UNICODE_FSS,
ASDSKRPT2 VARCHAR(15) CHARACTER SET UNICODE_FSS,
ASDSKRPT3 VARCHAR(15) CHARACTER SET UNICODE_FSS,
ZSDSKRPT1 VARCHAR(15) CHARACTER SET UNICODE_FSS,
ZSDSKRPT2 VARCHAR(15) CHARACTER SET UNICODE_FSS,
ZSDSKRPT3 VARCHAR(15) CHARACTER SET UNICODE_FSS,
ASSEM VARCHAR(80) CHARACTER SET UNICODE_FSS,
REV VARCHAR(1) CHARACTER SET UNICODE_FSS,
PROJ VARCHAR(20) CHARACTER SET UNICODE_FSS,
ASDEF BLOB SUB_TYPE 1 SEGMENT SIZE 4096 CHARACTER SET UNICODE_FSS,
ASABBILDUNG VARCHAR(20) CHARACTER SET UNICODE_FSS,
ZSABBILDUNG VARCHAR(20) CHARACTER SET UNICODE_FSS,
ASVIDEO VARCHAR(20) CHARACTER SET UNICODE_FSS,
ASVERW VARCHAR(80) CHARACTER SET UNICODE_FSS,
ZSVIDEO VARCHAR(20) CHARACTER SET UNICODE_FSS,
ZSAUDIO VARCHAR(20) CHARACTER SET UNICODE_FSS,
ZSTERM VARCHAR(80) CHARACTER SET UNICODE_FSS,
UPDAUTOR VARCHAR(31) CHARACTER SET UNICODE_FSS,
UPDDATUM DATE,
ZSABK VARCHAR(10) CHARACTER SET UNICODE_FSS,
ZSVERW VARCHAR(80) CHARACTER SET UNICODE_FSS,
ASQCODE BIGINT,
ZSQCODE BIGINT,
ZSPRGM VARCHAR(20) CHARACTER SET UNICODE_FSS,
DATUM DATE,
ZSSEM VARCHAR(80) CHARACTER SET UNICODE_FSS,
AUTOR VARCHAR(31) CHARACTER SET UNICODE_FSS,
ASVERWID BIGINT,
ZSVERWID BIGINT)
AS
DECLARE VARIABLE CNT INTEGER = 0;
BEGIN
//code of procedure
END^