Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Writing Character String Constants or Literals
(Continued from previous topic...)
How To Write Character String Constants or Literals?
Character string literals are used everywhere in Transact-SQL statements.
You need to learn some important rules on writing character string literals:
- Character string literals must be enclosed in single quotes as 'Welcome to FYIcenter.com!'.
- An empty string must be expressed as ''.
- Single quote characters inside a string must be expressed as two single quotes.
For example: 'It''s Sunday!'.
- Character strings use non-default character code pages must use the COLLATE clause to
provide the code page through a collate name. For example, 'Franšais' COLLATE French_CI_AS.
(Continued on next topic...)
- What Is a Constant or Literal?
- How To Write Character String Constants or Literals?
- What Is a Collation?
- How To Specify the Collation for a Character Data Type?
- What Happens If Strings Are Casted into Wrong Code Pages?
- How To Find Out What Is the Default Collation in a Database?
- How Fixed Length Strings Are Truncated and Padded?
- How To Enter Unicode Character String Literals?
- How To Enter Binary String Literals?
- How To Enter Date and Time Literals?
- Why I Can Not Enter 0.001 Second in Date and Time Literals?
- What Happens If Date-Only Values Are Provided as Date and Time Literals?
- What Happens If Time-Only Values Are Provided as Date and Time Literals?
- What Are Out-of-Range Errors with Date and Time Literals?
- What Happens If an Integer Is Too Big for INT Date Type?
- How Extra Digits Are Handled with NUMERIC Data Type Literals?
- How REAL and FLOAT Literal Values Are Rounded?
- What Are the Underflow and Overflow Behaviors on FLOAT Literals?