ASCII characters past 127

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  February 25, 2005 at 3:41 pm

  #60990

  For some reason, neither myself nor my coworkers have been able to find an easy spreadsheet for the ASCII characters past 127 on SQL Server.  Here is a simple script if you can you it. 

  DECLARE @Counter char(3),

   @SQL varchar(150)

  CREATE TABLE #ASCII_Table( [Char] varchar(1), [Dec] varchar(45))

  SELECT @Counter = '128'

  WHILE @Counter <= '255'

  BEGIN

   SELECT @sql = 'INSERT INTO #ASCII_Table( [Char], [Dec]) ' +

     'SELECT CHAR(' + @Counter + '), ' + CHAR(39) + @Counter + CHAR(39)

  -- PRINT @sql

   EXEC( @sql)

   SELECT @Counter = @Counter + 1

  END

  SELECT * FROM #ASCII_Table

  DROP TABLE #ASCII_Table

  I wasn't born stupid - I had to study.

• DSP-120308

  Hall of Fame

  Points: 3959

  More actions

  February 25, 2005 at 5:17 pm

  #544299

  Not sure if this is "easy" or not but..

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/html/_pluslang_ascii_character_codes_chart_1.asp

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  February 28, 2005 at 5:46 am

  #544392

  That was my point for posting this.  Look at CHAR(180) in this chart and then try selecting it from your query analyzer.  I bet you see a different result....  

  I wasn't born stupid - I had to study.