Hi, I need to convert a table field from varchar to long varchar.
I tried alter table myTable add myNewField long varchar but it failed with: -7032: SQL statement not allowed for column of data type LONG I successfully created a new table as a copy of myTable but with a LONG VARCHAR field instead the VARCHAR field. Then I tried to insert the data from my old table into the new one: insert into myBrandNewTable select mandant, id, name, content from myTable this failed with -7032, too. Is there a way to bring data from a varchar field into a long varchar field in another table using sql, or is there another possibility of converting the field without using a new table, or is it up to me writing a program which reads, converts and writes record for record? Thanks, R�diger -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
