Top "Varchar" questions

What is the difference between CHARACTER VARYING and VARCHAR in PostgreSQL?

John uses CHARACTER VARYING in the places where I use VARCHAR. I am a beginner, while he is an expert. …

database postgresql varchar varying

How to run a more than 8000 characters SQL statement from a variable?

I can use the following code for tiny little queries: DECLARE @sql VARCHAR(8000) SET @sql = 'SELECT * FROM myTable' Exec @sql …

sql sql-server sql-server-2008 tsql varchar

Is a VARCHAR(20000) valid in MySQL?

I’m in need of some clarification of the maximum length of a varchar field in MySQL. I’ve always …

mysql varchar

MySQL varchar index length

I have a table like this: CREATE TABLE `products` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(512) NOT NULL, `…

mysql indexing varchar

DB2 cast a large CLOB (> 32KB) into text?

I have a DB2 (9.5.1) table which is defined as follows: CREATE TABLE MY_TABLE ( ID INTEGER DEFAULT 0 NOT NULL, TEXT …

db2 varchar clob

Getting last 5 char of string with mysql query

I have to get last 5 numbers using mysql. My values are like YOT-A78514,LOP-C4521 ... I have to get only last …

mysql varchar

MySQL - Select only numeric values from varchar column

Consider the following table : create table mixedvalues (value varchar(50)); insert into mixedvalues values ('100'), ('ABC100'), ('200'), ('ABC200…

mysql sql numeric varchar

MySQL VARCHAR size limit

If I have a column in table with field of type VARCHAR(15) and if I try to insert data of …

mysql size varchar

Varchar(255) to Varchar(MAX)

Is it possible to change a column type in a SQL Server 2008 database from varchar(255) to varchar(MAX) without having …

sql types varchar

MySQL VARCHAR Lengths and UTF-8

In MySQL, if I create a new VARCHAR(32) field in a UTF-8 table does it means I can store 32 bytes …

mysql unicode utf-8 varchar