RTF and SQLite -- Data Type?


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,


Under SQLite there are no data types per se… but you may choose BLOB (raw data) for example.


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. :wink: