To retrieve the code page using the SQL statement

  • Hi,

    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.






  • select serverproperty('collation')  for server


    select databasepropertyex('dbname', 'collation') for a db

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply