Sim Zacks wrote: > > 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?
Unfortunately not. You have to use some kind of application using Python/ODBC/JDBC or the like. Elke SAP Labs Berlin > > Thanks > Sim > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
