Top "Varchar" questions

Convert dd/mm/yyyy to date in SQL Server

I'm going nuts trying to convert a string type column into date. The column name is StartDate, which contains a …

tsql date varchar sql-convert

How does MySQL varchar know how many bytes indicate the length?

The MySQL manual and several StackOverflow answers make it clear that varchar uses: 1 byte for varchars with 0-255 characters in …

mysql char byte varchar maxlength

How to calculate maximum length of VARCHAR type in DB2?

According to this: VARCHAR(n) Varying-length character strings with a maximum length of n bytes. n must be greater than 0 …

sql db2 varchar page-size

Inserting Superscript Numbers in MS SQL

Trying to insert a value into a varchar data field with the Superscript number of 4 (power of 4) at the end. …

sql insert varchar superscript

How can I make SQL Server return FALSE for comparing varchars with and without trailing spaces?

If I deliberately store trailing spaces in a VARCHAR column, how can I force SQL Server to see the data …

sql-server varchar

sp_executesql or exec(@var) is too long. Maximum length is 8000

I have large queries so i cant use linked server in production by rules. i pass a varchar(max) which …

sql-server-2005 varchar sp-executesql large-data

Convert varchar column to smalldatetime

I have a table with 800+ records. In this table I have a column named 'Data' of varchar(10) datatype which contains …

sql-server sql-server-2005 varchar smalldatetime

Select truncated string from Postgres

I have some large varchar values in Postgres that I want to SELECT and move somewhere else. The place they …

sql postgresql types casting varchar

PostgreSQL primary key length limit

What is the limit of the length of primary key column? I'm going to use varchar as primary key. I've …

postgresql primary-key varchar

Memory usage of storing strings as varchar in MySQL

I've begun to get very interested in the memory usage of MySQL. So I'm looking at this here: http://dev.…

mysql database-design memory-management varchar mysql-management