I defined a COMMENTS column as a LONG, and now we need to be able to search the column so I would like to convert it to a VARCHAR
I tried ALTER TABLE MODIFY COMMENTS VARCHAR(8000) and it said the field types were incompatible. I tried creating a new column and updating it UPDATE TBL1 SET COMMENTS2=COMMENTS and it said the field types were incompatible. I suppose I could call it in Python, put the result into a string and then send it back up, but that seems painfully the wrong way to do it. Is there any way through SQL to get data from a LONG column into a Varchar column? Thanks Sim -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
