varchar Archives - IT Nursery

Programming, sql

IT Nursery

I have a question about the ALTER TABLE command on a really large table (almost 30 millions rows). One of its columns is ...

Database, Programming

IT Nursery

In multiple courses, books, and jobs, I have seen text fields defined as VARCHAR(255) as kind of the default for “shortish” text. Is ...

MySQL, Programming

IT Nursery

What is the equivalent of varchar(max) in MySQL? 6 Answers 6

Programming, sql-server

IT Nursery

I just read that the VARCHAR(MAX) datatype (which can store close to 2GB of char data) is the recommended replacement for the TEXT ...

I’m trying to update the length of a varchar column from 255 characters to 500 without losing the contents. I’ve dropped and re-created ...

I’m working on a database for a small web app at my school using SQL Server 2005. I see a couple of schools ...

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

I would like to know what the max size is for a MySQL VARCHAR type. I read that the max size is limited ...

This question already has answers here: VARCHAR vs TEXT in MySQL (3 answers) Closed 2 years ago. When we create a table in ...

I want to create a varchar column in SQL that should contain N'guid' while guid is a generated GUID by .NET (Guid.NewGuid) – ...