PostgreSQL varchar can store Unicode with suitable database and client encodings. My example stores ЯНВАРЬ, the Russian word for January.
Unicode Lost: Finding Question Marks Left by varchar Conversion
Customer names turn into question marks, and an nvarchar column does not bring them back. Here is how it happens and how to repair it.
UNISTR and Unicode Escapes in SQL Server 2025
Build Unicode strings with UNISTR in SQL Server 2025, compare NCHAR, and preserve accented letters, Hindi text, and emoji in storage.
Sizing nvarchar Columns: How Long Should a Name Be?
A name fits the web form but fails in the table. Measure real lengths in characters and bytes before you choose a size.
Exporting CSV Files Without Losing Leading Zeros or Dates
A postal code like 00501 turns into 501 in a spreadsheet. See where the zero is lost, how to build a correct CSV line, and why quotes alone do not help.
LEN vs DATALENGTH: Trailing Spaces, Unicode Bytes and NULL
Compare LEN vs DATALENGTH for trailing spaces, Unicode, UTF-8, NULL, and MAX values before safely resizing SQL Server string columns.
Storing Emoji and Short Messages: nvarchar, UTF-8 and Length
Store emoji safely with nvarchar or UTF-8 varchar, compare LEN and DATALENGTH, and choose message limits that fit full Unicode.