Hello Jesus,

thanks for your suggestion. Unfortunately I need the solution to also
work on firebird versions that do not support the monitoring tables.
Best regards,

Jan

Am 25.08.2011 09:33, schrieb Jesus Garcia:

>
>
>
> El 25/08/2011, a las 09:06, Marsupilami79 <marsupilami79@...
> <mailto:marsupilami79%40gmx.de>> escribió:
>
> > Hello List,
> >
> > I want to enhance a connectivity layer, that I use, to automatically
> > request character set transliteration for blobs of sub type text. I
> > think for this to work, I need to know the character set ID of the blob
> > itself, which can be determined using isc_blob_lookup_desc() and the
> > target ID, which should be the ID of the character set used for the
> > connection, which I know no easy way to determine.
> > So the question is: Is there any easy way to get the character set ID,
> > which was assigned to the connection or do I have to query the ID from
> > RDB$CHARCTER_SETS using the character sets name?
> >
> > Thanks for your help and best regards,
> >
> > Jan
> >
> >
>
> You can get It from mon$attachments table, where there is a column
> with the charset of the connection.
>
> Jesus
>
>

[Non-text portions of this message have been removed]