MobileRead Forums - View Single Post - How do I convert a composite column to a regular text one?

chaley · 09-21-2021, 05:42 AM

You can't change the column type.

The best approach is to create a new column and delete the composite. That avoids the implicit type change because you aren't reusing the lookup key. If you really use the composite in only one place then delete it and then create the new column with the same lookup key.

09-21-2021, 05:42 AM	#2
chaley Grand Sorcerer Posts: 12,453 Karma: 8012886 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	You can't change the column type. The best approach is to create a new column and delete the composite. That avoids the implicit type change because you aren't reusing the lookup key. If you really use the composite in only one place then delete it and then create the new column with the same lookup key.