617 error

Greetings, I have a user that needs to insert a char into a text datatype. The following 617 error is being received. I've looked into cast's but not sure if it will work. The sql statement is below. I know I've seen chatter on this before but do not recall the solution. Any help would be greatly appreciated. 9.40 FC2w4 HPUX 11.11 Thanks -617 A TEXT or BYTE data type must be supplied within this context. This statement assigns a value that is not a simple large object to a BYTE or TEXT column or assigns a BYTE or TEXT column to a column that is not a simple large object. Neither action is supported. BYTE and TEXT values must be assigned as whole units to columns of the same type. Check that the statement specifies the columns that you intended. insert into ps_cx_age_cmnt (business_unit, cust_id, item, cx_comment_date, cx_oprid, comment_source, cx_caf_sup_review, cx_perm_message, cx_cmx_sup_review, cx_descrlong, cx_initials)select business_unit, cust_id, item, accounting_dt, "CARMAX", "C", " ", " ", " ", cx_comments, -- (This is the character field trying to insert into cx_descrlong, which is a text field) "N/A" from ps_cx_penditem where cx_comments <> ' ';