Normally refers to a variable length string data type.

learn more… | top users | synonyms

1
vote
1answer
37 views

Shrinking VARCHAR with MODIFY: data alignment and potential for data loss

I'm using MODIFY to change (shrink) a number of VARCHAR fields of various lengths in various tables. In each case, the field is called ip and is a textual representation of an IPv4 or IPv6 address. To ...
0
votes
1answer
47 views

Does PostgreSQL have a variable character storage layer that optimizes storage space by automatic dedupe?

My application has a Product and a Purchased table. The Purchased table includes a full copy of the Product row at time of purchase, so that, even if a product name or description was changed, the ...
0
votes
1answer
118 views

Implicitly (or proxy) convert to Nvarchar on incoming queries from legacy or 3rd party applications

We have a 3rd party application of which we don't have the source code. This application executes queries on our database without using the "N" prefix before literal strings. It does this in inserts ...
0
votes
0answers
5 views

Mysql copying from varchar column to a decimal coulmn

I have a column in MySQL table (First table) has varchar data type, I used JDBC driver to insert data of numerical data type on the mentioned column . Why I choose varchar data type of this type? ...
0
votes
0answers
48 views

Null in Varchar datatype

I am using a SQL Server database. If NULL value is inserted to a VARCHAR datatype column, what will be the memory size used for the column?
0
votes
0answers
20 views

Ascii Symbols are Shown In varchar and Datetime Column Values of Mysql

Some rows in my database are shown in binary format. DateTime values are shown as below in Sqlyog. DC1203-68-58 51:18:72 Æ420-94-57 38:13:76 \722-49-30 63:17:35 ETB801-61-42 37:69:60 When i ...
0
votes
0answers
46 views

Performance implications of mixing VARCHAR and CHAR fields in MySQL Table

I read the following answers in this forum: What is the performance impact of using CHAR vs VARCHAR on a fixed-size field? MySQL: Does the order of the fields in a table make a difference in ...