Top "Varchar" questions

Difference between BYTE and CHAR in column datatypes

In Oracle, what is the difference between : CREATE TABLE CLIENT ( NAME VARCHAR2(11 BYTE), ID_CLIENT NUMBER ) and CREATE TABLE CLIENT ( …

sql oracle unicode varchar

Difference between VARCHAR and TEXT in MySQL

When we create a table in MySQL with a VARCHAR column, we have to set the length for it. But …

mysql text varchar

Postgresql - change the size of a varchar column to lower length

I have a question about the ALTER TABLE command on a really large table (almost 30 millions rows). One of its …

sql postgresql varchar alter-table

SQL Server : error converting data type varchar to numeric

I have a table: Account_Code | Desc 503100 | account xxx 503103 | account xxx 503104 | account xxx 503102A | account xxx 503110B | account xxx Where …

sql-server numeric varchar

Equivalent of varchar(max) in MySQL?

What is the equivalent of varchar(max) in MySQL?

mysql varchar

Using varchar(MAX) vs TEXT on SQL Server

I just read that the VARCHAR(MAX) datatype (which can store close to 2GB of char data) is the recommended …

sql-server performance text varchar sql-types

PostgreSQL: ERROR: operator does not exist: integer = character varying

Here i am trying to create view as shown below in example: Example: create view view1 as select table1.col1,…

postgresql casting integer varchar

What are the main performance differences between varchar and nvarchar SQL Server data types?

I'm working on a database for a small web app at my school using SQL Server 2005. I see a couple …

sql-server sql-server-2005 storage varchar nvarchar

oracle varchar to number

How do i convert a oracle varchar value to number eg table - exception exception_value 555 where exception_value is …

oracle numbers varchar

SQL Server date format yyyymmdd

I have a varchar column where some values are in mm/dd/yyyy format and some are in yyyymmdd. I …

sql-server database date datetime varchar