Subject Re: [firebird-support] charachter set ID for the current connection
Author Jesus Garcia
El 25/08/2011, a las 09:06, Marsupilami79 <marsupilami79@...> 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.