varchar Archives - IT Nursery

Postgresql – change the size of a varchar column to lower length

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

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

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

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

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 … Read more

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

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

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

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

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