How can i determine the character set used by a client application (from Sybase ASE)?
Is there any way of getting, from the server side (Sybase ASE), the character set used by a client application?
I mean, i need to know through any Sybase ASE resource (system table data, global variable, environment variable, etc.) the specific character set used by any client application connected to Sybase ASE.
I've been looking for a while in the online documentation (Sybase ASE, Open Client/Software Developer´s Kit) without success.
Any help will be appreciated so much.
Rob Verschoor replied
You can get the charset used by the current session via the session-specific global variables @@client_csname or @@client_csid.
You cannot programmatically access this information for other connections than your own, but in case you just want to collect information about all charset used by connecting client applications, you can use a login trigger to capture this information for each session that connects to ASE (and for example insert the details into a table which you can inspect at a later time).