Creating A Picture Datatype Field

Nairaland Forum | Technology | Programming | Creating A Picture Datatype Field

Pages: (1)

Author

Topic: Creating A Picture Datatype Field (Read 196 views)

Lexy01 (m)

Creating A Picture Datatype Field

« on: May 26, 2007, 05:41 PM »

Please what datatype do i use to create a picture field in my database using microsoft Access

sbucareer (f)

Re: Creating A Picture Datatype Field

« #1 on: May 26, 2007, 06:22 PM »

Use BLOB (Binary Large Object) is an Oracle datatype that can hold up to 4 GB of data. Also see CLOB. BLOB's are handy for storing digitized information (eg, images, audio, video)

You can use CLOB (Character Large Object) is an Oracle datatype that can hold up to 4 GB of data.

They are both universal datatype, both would work with MS DB

Fdeveloper (m)

Re: Creating A Picture Datatype Field

« #2 on: May 26, 2007, 06:43 PM »

Specifically for Microsoft Access, you would use an "OLE Object" type which can be used to store various types of binary data. Check out the following link for an example: http://www.learnaccessnow.com/chap17b.html

Following on from sbucareer's tip, you may wish to consider migrating to Oracle if possible as it gives you a lot more functionality and better performance than Access.

Re: Creating A Picture Datatype Field

« #3 on: May 27, 2007, 06:24 PM »

Yeah BLOB is the data type you need. And it's not specific to Oracle database only. Any mature Database Management System must have a blob type.

By the way, you didn't tell us which database management system you are using.

As Fdeveloper said, you may need to leave access, if that's what you are using.
You may also consider Firebird(http://firebirdsql.org) as it has an embedded version that gives you the compactness of small databases like access and Sqlite and also the power of big server databases like Oracle and MSSQL plus it takes only 1.44Mb of hard disk space and can be bundled and deployed with your application.

Moriki (m)

Re: Creating A Picture Datatype Field

« #4 on: May 28, 2007, 04:51 PM »

Yeah i believe u IG.
because i have tried it, tested it , evaluated it and given my trust to it!
Try it Lexy01 and you will not regret!

I Need To Learn Java From The Scratch.any Gurus Here? Materials On Ccna I Want To Learn Java Page 2

Pages: (1)