How can I see all the “special” characters permissible in a varchar or char field in SQL Server? [closed]

by

You probably just need to see the ASCII and EXTENDED ASCII character sets. As far as I know any of these are allowed in a char/varchar field.

If you use nchar/nvarchar then it’s pretty much any character in any unicode set in the world.

enter image description here

enter image description here

More Related Contents:

  1. Syntax not valid on word ‘ON’ in SQL join statement [closed]
  2. Can anyone help me to get the query to retrieve data like below [closed]
  3. Need SQL Script
  4. Simple way to transpose columns and rows in SQL?
  5. Optimal way to concatenate/aggregate strings
  6. How can I delete using INNER JOIN with SQL Server?
  7. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  8. Convert varchar into datetime in SQL Server
  9. TSQL Pivot without aggregate function
  10. Fastest way to perform nested bulk inserts with scope_identity() usage?
  11. SQL performance on LEFT OUTER JOIN vs NOT EXISTS
  12. Why are there gaps in my IDENTITY column values?
  13. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  14. Execute Stored Procedure from a Function
  15. How do I perform a GROUP BY on an aliased column in SQL Server?
  16. How do I use ROW_NUMBER()?
  17. How to write UPDATE SQL with Table alias in SQL Server 2008?
  18. SQL Server 2008- Get table constraints
  19. Restrict an SQL Server connection to a specific IP address
  20. Search for “whole word match” with SQL Server LIKE pattern
  21. Why are logical reads for windowed aggregate functions so high?
  22. How to sum up time field in SQL Server
  23. SQL – Call Stored Procedure for each record
  24. Group All Related Records in Many to Many Relationship, SQL graph connected components
  25. How do I change db schema to dbo
  26. Is there a severe performance hit for using Foreign Keys in SQL Server?
  27. How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?
  28. Date serial in SQL?
  29. Parameterise table name in .NET/SQL?
  30. How to insert into a table with just one IDENTITY column?

Leave a Comment