Riho-Rene,


Riho-Rene Ellermaa schrieb:

>
> Thanks! That was it.
> But strange, I have set database default WIN1252 and dialect 1
> I haven't had any problems with other queries

Where did you set this?
In the IB_Connection?

If so, this has got _NOTHING_ to do with the default character set of
the database.
The default character set can _ONLY_ be set when the database is
created.

A stored proc is running on the server and doesn't know anything about
settings of your connection - these are just settings for the client (so
this is the reasons your queries are working without problem) thus
telling the components how to "handle/translate" the result sets.


Luc.