Top "Varchar" questions

Prevent empty strings in CHARACTER VARYING field

I am using PostgreSQL and would like to prevent certain required CHARACTER VARYING (VARCHAR) fields from allowing empty string inputs. …

postgresql constraints varchar

Are there any benefits to using sql_variant over varchar in SQL Server?

I currently have a database table setup as follows (EAV - business reasons are valid): Id - int (PK) Key …

c# performance sql-server-2012 varchar sql-variant

varbinary to varchar w/o master.dbo.fn_varbintohexstr

Is there any way to convert varbinary to ASCII varchar string (base64, md5, sha1 - no matter) without master.dbo.…

sql sql-server-2005 varchar varbinary

varchar Fields - Is a Power of Two More Efficient?

Is it more efficient to use a varchar field sized as a power of two vs. another number? I'm thinking …

database-design varchar

Should I use an inline varchar(max) column or store it in a separate table?

I want to create a table in MS SQL Server 2005 to record details of certain system operations. As you can …

sql-server normalization varchar