Top "Varchar" questions

A varchar or variable character field is a set of character data of indeterminate length.

SQL BETWEEN for text vs numeric values

BETWEEN is used in a WHERE clause to select a range of data between two values. If I am correct …

mysql sql numbers varchar between
Validate DateTime before inserting it into SQL Server database

Is there any way to validate datetime field before inserting it into appropriate table? Trying to insert with try/catch …

c# sql-server-2008 validation datetime varchar
why is CONVERT string to VARBINARY in SQL Server only converting first character?

I am using NLog to log in my application and as part of that we are logging the customer number, …

sql nlog varchar varbinary
Does VARCHAR size limit matter?

Possible Duplicate: Importance of varchar length in MySQL table When using VARCHAR (assuming this is the correct data type for …

php mysql database-design varchar
#1054 - Unknown column

I am using MySQL 5.5 and phpmyadmin 3.5.2 (provided by http://www.freewebhostingarea.com) My sql query is: INSERT INTO `example`(`id`, `…

mysql sql varchar sqldatatypes mysql-error-1054
How do I know if my PostgreSQL server is using the "C" locale?

I'm trying to optimize my PostgreSQL 8.3 DB tables to the best of my ability, and I'm unsure if I need …

postgresql text indexing locale varchar
Migrating Varchar to Text in Mysql

I am converting one of the "Varchar" column in mysql table to a text field. I am simply using single …

mysql text varchar
Can the French and Spanish special chars be held in a varchar?

French and Spanish have special chars in them that are not used in normal English (accented vowels and such). Are …

sql unicode character-encoding varchar
What is the advantage of using varbinary over varchar here?

A while ago I asked a question about hierarchy/version number sorting in SQL Server. ( How Can I Sort A …

sql sql-server varchar varbinary
Performance of string comparison vs int join in SQL

It's accepted that searching a table on an int column is faster than on a string column (say varchar). However, …

sql performance join foreign-keys varchar