On Mon, Jul 29, 2013 at 4:22 PM, Randy Westlund <rwest...@gmail.com> wrote:
> Hey guys,
>
> I'm planning to set up an SQL server for my dad's small canvas awning 
> business, and I've never done this before.  Most of my sysadmin-type skills 
> are self-taught.  I could use some advice.
>

Heh, based on the capitalized subject line I was going to ask why you
were asking about Microsoft SQL Server on this list. ;-)

> Table structure:
>
> I'm diving into database design and normalization rules now.  I'll need to 
> store binary files (pictures of job site, scanned documents), and am 
> currently planning on base64 encoding them (or something similar) and storing 
> them in the database to keep it ACID compliant.

If you really want to store binary data in the database, use a binary
(BLOB) data type. Base64 will increase their size significantly.

Reply via email to