Subject TIB_StoredProc problem
Author Riho-Rene Ellermaa
IBO 4.2 Fp, BCB 5 Prof.

I get error "cannot transliterate between charsets" if I want to execute StoredProc
and the records NAME field contains accented symbols ("öäoü").
If I run the same proc in IBAdmin, then it works OK.

I can also save accented symbols without problems using TIB_Query.
TIB_StoredProc's IB_Connection and IB_Transaction are the same as in TIB_Query,
IB_Connection charset is WIN1252.

What else should I ceck?


CREATE PROCEDURE COPY_MASS (DOCID INTEGER,
NEWID INTEGER,
STARTDOC INTEGER,
PREF VARCHAR(10),
SUFF VARCHAR(10))
returns (NEWDOCNO INTEGER)
AS
declare variable row Integer;
declare variable amount numeric(15,2);
declare variable account varchar(16);
declare variable bank varchar(12);
declare variable docno varchar(10);
declare variable regno varchar(11);
declare variable cref varchar(28);
declare variable name varchar(70);
begin
for select row,amount,account,bank,regno,cref,name from mass_detail where id=:docid into :row,:amount,:account,:bank,:regno,:cref,:name
do
begin
startdoc=startdoc+1;
docno=pref||cast(startdoc as varchar(8))||suff;
insert into mass_detail (id,docno,row,amount,account,bank,regno,cref,name ) values (:newid,:docno,:row,:amount,:account,:bank,:regno,:cref,:name);
end
Newdocno=startdoc;
end



Riho-Rene Ellermaa
senior programmer
Hansabank