RTF and SQLite -- Data Type?

  1. 5 months ago


    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,


  2. Javier M

    Jul 8 Pre-Release Testers, Xojo Pro, Third Party Store AprendeXojo - Europe, Spain

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


  3. Dave S

    Jul 8 San Diego, California USA

    or in a Text field, since RTF only contains UTF-8 characters if I am not mistaken

  4. Jean-Yves P

    Jul 8 Pre-Release Testers, Xojo Pro Europe (France, Besançon)

    TEXT is fine for storing RTF

  5. Jonathan A

    Jul 8 Pre-Release Testers Maryland, USA

    RTF is ASCII, not UTF-8. The encoding flavor for values >127 can be defined in the protocol.

  6. Thank you! I appreciate your responses... I wasn't sure if there was a specific type that I "should" be using. ;-)

or Sign Up to reply!