Specify a string

Some of the search text you want to insert into the table is not stored in operating system files since it is small. In this case, you can enter it directly into the IfxMRData column, as you would enter data into a standard SQL character column, as shown in the following example:
INSERT INTO videos2 (id, name, description)
    VALUES( 
        1010, 
        'The Unforgiven',
        'Academy-award winning western directed by Clint Eastwood.' );

Since the data entered into the description column is smaller than 2 KB, the data is stored as an LVARCHAR object.