Design database to hold html, jsp, java, javascript, etc code
===

i want to build a small tool to save useful code snippet in the database. But don't know which kind of datatype should I use to hold all the codes. Is there problem with `special characters`? can I use `String` to hold code? can you please give me some advice? thank you in advance.

**UPDATE**

i am going to make a table like:

-- ID (String) -- -- NAME (String) -- -- TYPE (String) -- -- CODE (String) --

to save code. any tips?