Top "Varchar" questions

How to get the size of a varchar[n] field in one SQL statement?

Suppose that I have a SQL table that has a varchar[1000] field called "Remarks". I would like to craft a …

sql sql-server-2008 varchar

How to convert Varchar to Double in sql?

I have problem with my query when I was trying to convert the varchar field to double (numeric). I have …

mysql sql numeric varchar

How many characters in varchar(max)

How many characters can a SQL Server 2008 database field contain when the data type is VARCHAR(MAX)?

sql-server-2008 size varchar

MySQL VARCHAR size?

I'm wondering, if I have a VARCHAR of 200 characters and that I put a string of 100 characters, will it use 200 …

mysql varchar

Is the LIKE operator case-sensitive with MSSQL Server?

In the documentation about the LIKE operator, nothing is told about the case-sensitivity of it. Is it? How to enable/…

sql sql-server-2005 varchar sql-like

Is there a good reason I see VARCHAR(255) used so often (as opposed to another length)?

In multiple courses, books, and jobs, I have seen text fields defined as VARCHAR(255) as kind of the default for "…

database database-design types varchar

What does it mean when the size of a VARCHAR2 in Oracle is declared as 1 byte?

I know that I can declare a varchar2 using the number of the characters that it should be able to …

sql oracle varchar sqldatatypes

When increasing the size of VARCHAR column on a large table could there be any problems?

I'm using SQL Server 2008 and I need to make a VARCHAR field bigger, from (200 to 1200) on a table with about 500…

sql-server sql-server-2008 varchar alter-column

Finding rows that don't contain numeric data in Oracle

I am trying to locate some problematic records in a very large Oracle table. The column should contain all numeric …

sql oracle varchar numeric varchar2

Can I use VARCHAR as the PRIMARY KEY?

I have a table for storing coupons/discounts, and I want to use the coupon_code column as the primary …

mysql sql primary-key unique varchar