MobileRead Forums - View Single Post - Change datatype from text to comma separated?

rantanplan · 11-25-2024, 05:00 AM

I have a column in Calibre where I document how I got the ebook. E.g. Kindle, Kobo, Humblebundle etc. Sometimes I have multiple copies of the same book from different sources, but when I set this column up, it was configured as a text field (in tag browser).

Is it possible to change this column to comma separated text by manipulating a table in the sqlite database itself? I'd create a backup first, obviously, but would that be possible?

11-25-2024, 05:00 AM	#1
rantanplan Weirdo Posts: 836 Karma: 11003000 Join Date: Nov 2019 Location: Wuppertal, Germany Device: Kobo Sage, Kobo Libra 2, Boox Note Air 2+	Change datatype from text to comma separated? I have a column in Calibre where I document how I got the ebook. E.g. Kindle, Kobo, Humblebundle etc. Sometimes I have multiple copies of the same book from different sources, but when I set this column up, it was configured as a text field (in tag browser). Is it possible to change this column to comma separated text by manipulating a table in the sqlite database itself? I'd create a backup first, obviously, but would that be possible?