Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How can i determine the character set used by a client application (from Sybase ASE)?

Hi there.

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.

Kind regards.

Franklin

Tags:
Former Member
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).

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question