View Single Post
Old 09-18-2022, 01:59 AM   #3
Amalthia
Wizard
Amalthia does all things with Zen-like beautyAmalthia does all things with Zen-like beautyAmalthia does all things with Zen-like beautyAmalthia does all things with Zen-like beautyAmalthia does all things with Zen-like beautyAmalthia does all things with Zen-like beautyAmalthia does all things with Zen-like beautyAmalthia does all things with Zen-like beautyAmalthia does all things with Zen-like beautyAmalthia does all things with Zen-like beautyAmalthia does all things with Zen-like beauty
 
Amalthia's Avatar
 
Posts: 1,188
Karma: 32196
Join Date: Jan 2007
Location: Anchorage, AK
Device: Sony Reader PRS-505, PRS-650, PRS-T3, Pocketbook HD2
Quote:
Originally Posted by ownedbycats View Post
Personally, I used integers for my #chaptercount column.

They take up the same amount of database resources.

Integer column is for numbers. If you think you may want to use arithmetic on the numbers in the future, use Integer.

You can put numbers in a text column, but there it'll be more treated like a string of characters. The main disadvantage is that it may not sort the way you expect.
Thanks for the input. I decided to go with integers.
Amalthia is offline   Reply With Quote