storing image to Database

[Ajith P T]

hi all, how can i store the image file(.jpg,.gif,.bmp etc) to database. i am using SQl Server 2000. what will be the datatype of the field thank you all

[toxcct]

type : binary. works fine for me for jpg, jpg, bmp and so...

---

TOXCCT >>> GEII power
[toxcct][VisualCalc]

[thealca]

How do u store it programmatically, I am using VB 6.0 / .Net for example? :doh:

[chuotcoikeo]

Why are use type data is image

[toxcct]

sorry, maybe my englishis too poor to understand yours... but i'd like you to reformulate your query please...

---

TOXCCT >>> GEII power
[toxcct][VisualCalc]

[toxcct]

actually, i did it wihin a java code, but the server was a SQL Server 2000. do you want it nevertheless ?

---

TOXCCT >>> GEII power
[toxcct][VisualCalc]

[Anonymous]

If you don't mind yes, I'm also coding in java more basics only Thank You.

[toxcct]

if (getPicture() != null) {
ByteArrayInputStream inStream;
inStream = new ByteArrayInputStream(getPicture());
rqt.setBinaryStream(1, inStream, inStream.available());
// Where rqt is a PreparedStatement
}

in my bean :

private byte\[\] picture;

public byte\[\] getPicture() {
    return picture;
}

---

TOXCCT >>> GEII power
[toxcct][VisualCalc]