STRING types (VARCHAR)

String literals in SQL are enclosed in single quotes. Double quotes are reserved for identifiers (table and column names). This is a common source of confusion for beginners. Choosing String Types Different string types suit different use cases based on length variability and storage needs. One of the most common string operations is measuring how long a value is. Try it yourself. Single quotes delimit string literals in SQL while double quotes delimit identifiers like table and column names. Mixing them up is one of the most frequent syntax errors for SQL beginners.