Top "Varchar" questions

How to change VARCHAR type to DATETIME using ALTER in MySQL?

How can I change VARCHAR() type to DATETIME using ALTER in MySQL?

mysql datetime sql-update varchar alter-table

Why does VARCHAR need length specification?

Why do we always need to specify VARCHAR(length) instead of just VARCHAR? It is dynamic anyway. UPD: I'm puzzled …

sql database varchar

MySQL too long varchar truncation/error setting

I have two MySQL instances. The 1st one truncates strings on insert when data is too long. The 2nd one …

mysql settings varchar

MySQL - TEXT vs CHAR and VARCHAR

Reading this question, a doubt popped into my head: char and varchar can store up to 255 chars text can store …

mysql text types char varchar

Why should I ever choose any other length than 255 for varchar in MySQL?

I know the differnce between CHAR and VARCHAR, CHAR - Fixed length VARCHAR - Variable length (size + 1 byte) But I …

mysql char varchar

What is the maximum size limit of varchar data type in sqlite?

I'm new to sqlite. I want to know the maximum size limit of varchar data type in sqlite? can anybody …

sqlite size varchar

Storing leading zeros of integers in MySQL database as INTEGER

I need MySQL to store numbers in a integer field and maintain leading zeros. I cannot use the zerofill option …

php mysql string integer varchar

How to store a string var greater than varchar(max)?

I'm trying to do this: DECLARE @myVar VARCHAR(MAX) Loop with cursor select @myVar = @myVar + bla bla bla end loop …

sql sql-server-2005 max varchar string-concatenation

T-SQL: How to obtain the exact length of a string in characters?

I'm generating T-SQL SELECT statements for tables for which I have no data type information up-front. In these statements, I …

tsql string varchar nvarchar

ORA-12899 value too large for column despite of same length

I am running the following query. But getting ORA-12899. Altough the length of string am trying to insert is 30. INSERT …

sql oracle varchar varchar2