Technical Article

ASCII table and UNICODE table

,

ASCII table and UNICODE table

You can easily change the font of "SQL Query Analyzer":
TOOLS/OPTIONS/FONTS

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE ASCIItable 
--usage:
--exec dbo.asciitable
AS
DECLARE @i int,@j int, @c VARCHAR(100)
SET @i=32
WHILE @i<=255
BEGIN
SET @j=0
SET @c=''
WHILE @j<=7
BEGIN
SET @c=@c+right('   '+CONVERT(VARCHAR(3),@i), 3)+' '+ CHAR(@i)+'    '
SET @j=@j+1
SET @i=@i+1
END
PRINT @c
END
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE UNItable  AS
--UNICODE table
declare @i int, @c nchar(1), @line nvarchar(4000)
SET @i=32
SET @line=''
WHILE @i<65536
BEGIN
SET @c=NCHAR(@i)
SET @line=@line+ RIGHT('    '+rtrim(convert(nchar(7),@i)),6)+' '+@c+'  '
if ((@i-31) % 12=0)or (@i=65535)
BEGIN
PRINT @line
SET @line=''
END
SET @i=@i+1
END
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

Rate

Share

Share

Rate