Hello,
I have a TextArea that allows users to enter in Rich Text Formatted (RTF) text. However, I need to store this data in a SQLite database. Which SQLite data type would be best for storing / retrieving the RTF formatted text? Suggestions?
Thank you,
Byron
Under SQLite there are no data types per se but you may choose BLOB (raw data) for example.
Javier
or in a Text field, since RTF only contains UTF-8 characters if I am not mistaken
TEXT is fine for storing RTF
RTF is ASCII, not UTF-8. The encoding flavor for values >127 can be defined in the protocol.
Thank you! I appreciate your responses… I wasn’t sure if there was a specific type that I “should” be using.