To retrieve the code page using the SQL statement

• Dheeraj Singh Gang

  Grasshopper

  Points: 12

  More actions

  June 4, 2004 at 12:54 am

  #111549

  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.

   

   

   

   

   

• wz700

  SSCertifiable

  Points: 7133

  More actions

  June 4, 2004 at 2:48 am

  #508970

  select serverproperty('collation')  for server

  or

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