Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
INSERT statementUse the INSERT statement to insert one or more new rows into a table or view, or to insert one or more elements into an SQL or collection variable.
VALUES Clause
Truncated CHAR Values

Truncated CHAR Values

In a database that is not ANSI-compliant, if you assign a value to a CHAR(n) column or variable and the length of that value exceeds n characters, the database server truncates the last characters without raising an error. For example, suppose that you define this table:

CREATE TABLE tab1 (col_one CHAR(2);

The database server truncates the data values in the following INSERT statements to "jo" and "sa" respectively, but does not return a warning:

INSERT INTO tab1 VALUES ("john");
INSERT INTO tab1 VALUES ("sally");

Thus, in a database that is not ANSI-compliant, the semantic integrity of data for a CHAR(n) column or variable is not enforced when the value inserted or updated exceeds the declared length n. (But in an ANSI-compliant database, the database server issues error -1279 when truncation of character data occurs.)

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.