BINARY
- From: info@xxxxxxxxxxxxx
- Date: 31 May 2006 09:32:32 -0700
Hello all,
I want to export a field type like BINARY, VARBINARY, LONGVARBINARY
from a table save the result in a file (for example xml) and insert it
later to another table.
Could i read the result with getString() or should i read it with
getBinary and change it then to String to store it in the file?
How do I insert it with PreparedStatement?
Like this:
PreparedStatement pstmt = conn.prepareStatement("INSERT INTO table
('test') VALUES ('?' );
byte[] varByte = xmlValue.getBytes();
pstmt.setBinary(1,varByte);
That doesn't work, i will get some sh...
How do I handle binary-Fields when I like to save it in the time
between export and import?
Thanx to all...
Stefan
.
- Follow-Ups:
- Re: BINARY
- From: joeNOSPAM@xxxxxxx
- Re: BINARY
- Prev by Date: Re: Two more Access/Java questions
- Next by Date: Re: BINARY
- Previous by thread: DBPool : JDBC Connection Pooling - v4.8.2 released
- Next by thread: Re: BINARY
- Index(es):