Top "Varchar" questions

A varchar or variable character field is a set of character data of indeterminate length.

Are there disadvantages to using VARCHAR(MAX) in a table?

Here is my predicament. Basically, I need a column in a table to hold up an unknown length of characters. …

sql-server varchar nvarchar
Does a varchar field's declared size have any impact in PostgreSQL?

Is VARCHAR(100) any better than VARCHAR(500) from a performance point of view? What about disk usage? Talking about PostgreSQL today, …

postgresql performance varchar disk-access
Size of varchar columns

In sql server does it make a difference if I define a varchar column to be of length 32 or 128?

sql-server optimization varchar
Safe casting VARCHAR to DECIMAL in Teradata

In Teradata DB I have source table create set table SRC_TABLE ( Some_Id varchar(2O) not null ); This table …

casting decimal varchar teradata isnumeric
What is the maximum range of varchar in MySQL?

What is the maximum range of varchar in MySQL? I am using the latest version of MySQL and in many …

mysql varchar sqldatatypes
T-SQL: Converting NTEXT to VARCHAR to INT/BIGINT

I have a table with a field of type NTEXT which stores many type of values, filesize among them. I'm …

sql-server tsql varchar bigint ntext
VARCHAR versus TEXT or LONGTEXT

If a blog post is 200 characters long, will varchar(6500) only consume the space of varchar(200)? Will this be more efficient …

sql varchar longtext
MySQL varchar(2000) vs text?

I need to store on average a paragraph of text, which would be about ~800 characters in the database. In some …

mysql text varchar
Hibernate map enum to varchar

Suppose I have this enum: public enum TestEnum { EXAMPLE, FURTHER_EXAMPLE, LAST_EXAMPLE } With this mapping in the .hbm: <…

hibernate enums hibernate-mapping varchar
char vs varchar for performance in stock database

I'm using mySQL to set up a database of stock options. There are about 330,000 rows (each row is 1 option). I'm …

mysql sql performance varchar