Riho-Rene Ellermaa schrieb:

>
> 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?

Which character set was the db created with?

I suspect it was another one; all the chars/varchars you define in a
stored proc will have the same character set as rthe database by
default.

You can change you definitions to sth like:

declare variable account varchar(16) CHARACTER SET WIN1252;
declare variable bank varchar(12) CHARACTER SET WIN1252;
declare variable docno varchar(10) CHARACTER SET WIN1252;
declare variable regno varchar(11) CHARACTER SET WIN1252;
declare variable cref varchar(28) CHARACTER SET WIN1252;
declare variable name varchar(70) CHARACTER SET WIN1252;


Luc.