Defining and Storing pre-formatted code snippets

My use case is that I want to be able to store code snippets in an RDBMS (more specifically SQLite). The code snippets will be pre-formatted text which I want to be able to read exactly as I define.

My initial thinking was to create a CSV file which will define the pre-formatted code and import into the DB, the datatype used in the DB would most likely be a BLOB. When I read back from the DB I would just use a String datatype on the app side to store.

I'm not sure if this is the right approach so was hoping for some input on the design of this beforehand.

Thanks in advance!