#varchar

Difference between varchar and varchar(max) in SQL Server

Hello Readers,

The purpose of this post is to make it clear what to use and when with respect to varchar data type in SQL Server.

Varchar(max) was introduced in SQL Server 2005 version. A few years back, I wasn’t clear about the Difference between varchar and varchar max. It was always confusing for me which one to use.

[bctt…

Heyooo, first substantial post. 

There’s always a weird performative aspect to using social media of any form, but I’m going to try to not spend too much time writing/editing each post so as to maximize productivity and workflow. 

Something I was thinking about today: what’s the difference between the VARCHAR and TEXT types in SQL for the W3D2 project? I dug up some info from SO. Quassnoi from SO writes: 

TEXT is good:

If you need to store large texts in your database

If you do not search on the value of the column

If you select this column rarely and DO NOT join on it.

VARCHAR is good:

If you store little strings

If you search on the string value

If you always select it or use it in joins.

Some examples of what TEXT is good for:

Blog comments

Wiki pages

Code source

Some examples of what VARCHAR is good for:

Usernames

Page titles

Filenames

As a rule of thumb, whenever you need your text value to exceed 200 characters AND do not use join on this column, use TEXT.

Otherwise use VARCHAR. 

Macros para el tratamiento de VARCHAR

Macros para el tratamiento de VARCHAR.

#define vcharcpy(x, y) {strncpy((char *) x.arr, (char *) y.arr,\ (unsigned int) y.len);\ x.len = y.len; x.arr[x.len] = (unsigned char) NULL;} /* Copia varchar Y en varchar X y delimita el varchar X con NULL */

#define vcharlim(x) x.arr[x.len] = (unsigned char) NULL /* Delimita varchar X…

How to: #1071 – Specified key was too long; max key length is 767 bytes

#1071 – Specified key was too long; max key length is 767 bytes

When I executed the following command:

ALTER TABLE `mytable` ADD UNIQUE ( `column1` , `column2` );

I got this error message:

#1071 - Specified key was too long; max key length is 767 bytes

Information about column1 and column2:

column1 varchar(20) utf8_general_ci column2 varchar(500) utf8_general_ci

I think varchar(20)only…

Fixed What are the main performance differences between varchar and nvarchar SQL Server data types? #dev #it #asnwer

What are the main performance differences between varchar and nvarchar SQL Server data types?

I’m working on a database for a small web app at my school using SQL Server 2005. I see a couple of schools of thought on the issue of varchar vs nvarchar:

Use varchar unless you deal with a lot of internationalized data, then use nvarchar.

Just use nvarchar for everything.

I’m beginning to see the…

Fixed SQL Server Text type vs. varchar data type #dev #it #asnwer

SQL Server Text type vs. varchar data type

I have variable length character data and want to store in SQL Server (2005) database. I want to learn some best practices about how to choose TEXT SQL type or choose VARCHAR SQL type, pros and cons in performance/footprint/function.

Answer: SQL Server Text type vs. varchar data type

TEXTis used for large pieces of string data. If the length of the…