Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is a VARCHAR?

April 26, 2017varchar

0

0 Posted

What is a VARCHAR?

1 Answer

0

0 Posted

Here is a short description of VARCHARs: VARCHAR2 A kind of column in the database that contains variable-length character data. This is what Oracle calls an “internal datatype”, because it is a possible column type. VARCHAR An Oracle “external datatype” (datatype code 9). You use this only if you are doing dynamic SQL Method 4, or datatype equivalencing. VARCHAR[n] varchar[n] This is a Pro*C/C++ “pseudotype” that you can declare as a host variable in your Pro*C/C++ program. It is actually generated by Pro*C/C++ as a struct, with a 2-byte length element, and a [n]-byte character array.