Hello,
I have a need to store a shell script or two in each database records. What is the best way to store the shell script data in the database? I guess I wanted to know if it makes more sense to just store the text of the script or store it as a file in a blob? Oh yea, the data will only be accessed via web services.

Thanks!

I can't see any advantage to using a blob so I'd say use a character field. Whether you use a large varchar or a text field depends on the size of your scripts. Saying that it may be better to just keep your shell programs in the file system and then just store the name of the script and the params it takes in your database.