I want to retrieve the code page from SQL Server using SQL statement. Please reply anbody have some idea.
Actually I know regarding the oracle. If you fire below statement it returns you the characterset defined:
select VALUE from v$nls_parameters where PARAMETER = 'NLS_CHARACTERSET'
Return value may be WE8ISO8859P9 used for all european languages.
Similar I would like to know for the SQL Server.
Thanks in advance.