Fixed field index issue

[bart]

I created a table with a char(250) field and then issued an insert command which selected data from a blob field in another table. The plan was to create a truncated version of the original blob field. I then attempted to create an index on the fixed field and got the following message (repeated many times):

005 Bad size 250 for column b; truncated data at offset 0x8 in recid 0x549E6 of /tmp/tst/b.tbl in the function fbuftofld

The index was created, but what error is the message indicating?

Also, it would be helpful if putmsg() could recognize repeated error messages and then suppress the repetitions beyond 3 or 4 and just give the count.

[John]

The direct conversion of blob to fixed character did not work correctly. You can do the insert as:

insert into newtable select convert(blobfield, 'varchar') from oldtable;