Top "Varchar" questions

What to do when you need integers larger than 20 digits on mysql?

Seems like BIGINT is the biggest integer available on MySQL, right? What to do when you need to store a …

mysql int varchar bigint

How can Hibernate map the SQL data-type nvarchar(max)?

I have a column in my SQL-2005 database that used to be a varchar(max), but it has been changed …

sql-server-2005 hibernate varchar nvarchar

varchar(max) MS SQL Server 2000, problems?

I've inherited a asp.net website project that currently runs SQL Server 2000 as its backend. I've been doing some databases …

sql sql-server varchar

Postgres: Convert varchar to text

I screwed up and created a column as a varchar(255) where that is no longer sufficient. I've read that varchar …

postgresql text varchar

What does varchar(-1) mean?

What is the meaning of varchar(-1) in SQL Server 2008? Is it an alternative for varchar(max)?

sql sql-server sql-server-2008 varchar

Make a varchar(50) column unique

I have a column (which represents an e-mail) in a SQL Server database with varchar(50) as data type and I …

sql-server unique varchar

What size to pick for a (n)varchar column?

In a slightly heated discussion on TDWTF a question arose about the size of varchar columns in a DB. For …

database-design size varchar nvarchar

MySQL different treatment between VarChar(255) and VarChar(65536)

Does anyone know the difference between using VarChar(255) and VarChar(65536) ? Here's what I know so far : VarChar(255) will only use …

mysql varchar

Converting Varchar to NVarchar?

I know when converting from nvarchar to varchar, some data will be lost/changed. However, are there any risks of …

sql sql-server-2008 varchar nvarchar sqldatatypes

Mapping to varchar and nvarchar in hibernate

If there are 2 columns in database, eg. code varchar(3) name nvarchar(50) How to tell hibernate to pass varchar for searching …

sql hibernate varchar nvarchar