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.

Im confused by VARCHAR. Whats a VARCHAR?

April 26, 2017confused varchar

0

Posted

Im confused by VARCHAR. Whats a VARCHAR?

1 Answer

0

Posted

Here’s 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’s a possible column type. See “VARCHAR2” on page 3-20. VARCHAR An Oracle “external datatype” (datatype code 9). You use this only if you’re doing dynamic SQL Method 4, or datatype equivalencing. See “VARCHAR” on page 3-22 for datatype equivalencing, and Chapter 14, “Using Dynamic SQL: Advanced Concepts”. 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’s actually generated by Pro*C/C++ as a struct, with a 2-byte length element, and a [n]-byte character array. See “Declaring VARCHAR Variables” on page 3-43.