assigning char to BLOB-field (memo)

[Guest_imported]

update person
set expirience = cv
where id=1

Field experience = BLOB (memo)
Field cv = CHAR(255)

This doesn't work, unfortunately.

update person
set experience = "bla bla bla"
where id=1

This does work, but I can't asign (first SQL)
a CHAR field to the BLOB field (experience).

 

[rwb1959]

Can your BLOB datatype be a CLOB datatype?

I have not tried this but I believe you can implicitly
convert CHAR to CLOB for your purposes.