|
I've tried all forms of encoding. It worked in
MySQL without and encoding attribute set.
The value that's being inserted is being quoted in
the SQL.
I haven't tried getting the VARCHAR option. How
would I go about getting a char count, and how would this help me verify the
image in the database vs the one I'm trying to upload? Like I said in my first
post, I think the image is getting corrupted about halfway through when I use
the ODBC connection. What I don't understand is why. And more for curiosity's
sake than anything else, I would like to know why OCI doesn't seem to work at
all.
Thanks Ben!
Cheers,
Jonah Simpson
----- Original Message -----
Sent: Wednesday, January 21, 2004 10:57
AM
Subject: RE: Witango-Talk: uploading
images from form into Oracle via different connections [possibly OT] [possibly
OT]
I see you
point.
Are you specifying
any encoding on the ARG on the insert?
What about
quotes?
Have you tried
creating a VARCHAR column in the database and then get a char
count.?
-----Original
Message-----
From: Jonah
Simpson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 12:32
PM
To:
[EMAIL PROTECTED]
Subject: Re: Witango-Talk: uploading
images from form into Oracle via different connections [possibly OT] [possibly
OT]
Yeah, the image has no problem
writing to the filesystem. But I'm not sure that rules out WiTango, because
writing to the filesystem and outputting to and ODBC or OCI connection would
be two very different bits of code. However, I am beginning to wonder if
there's some setting for the field in Oracle, or even for the table or
database that I need to use to make this happen. Surely someone's made this
work using Oracle or had the same problem I'm having?
----- Original Message -----
Sent:
Wednesday, January 21, 2004 6:56 AM
Subject: RE:
Witango-Talk: uploading images from form into Oracle via different
connections [possibly OT] [possibly OT]
Ok, not doing
anything with Oracle, but here is way to rule out Witango.
The image is sent
as a postarg. So just do a file write action and save the data coming in
directly to a jpg and view the jpg. If it views ok then the image is coming
over correct.
-----Original
Message-----
From: Jonah
Simpson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 3:03
AM
To:
[EMAIL PROTECTED]
Subject: Witango-Talk: uploading images
from form into Oracle via different connections [possibly OT] [possibly
OT]
Hey All!
In an issue I hate
revisiting, I've got a problem uploading images (jpg)
from a form into an
Oracle database. This time I've done a bit more
experimentation on the
code but I still don't have a solution to get it
work.
Basically,
what I'm trying to do is take a file submitted with
<input
type="file"....> via <form encytype="multipart/form-data"
...> and store it
in a BLOB field in Oracle 8.2 using OCI. I'm using
Windows 2000, Apache 2.0,
Witango 5.0.
The code I'm working on had
previously been run on a Sun box, with
Witango2000 and prior and Apache
(not sure of version). During an upgrade of
either Apache or WiTango the
code stopped working. There are images in the
database from when the
routine worked, and I can download them and display
them using <img
src="" ...> without a problem.
Here's where it
gets weird. I was concerned that it was an Apache upgrade
that broke the
routine. So I tried moving the information over to a MySQL
database
figuring I'd get the same problem. But it worked fine! So now I
began
thinking that this problem was maybe related to the database
connection
method. So I tried using the Oracle ODBC and the Microsoft Oracle
ODBC.
The MS Oracle ODBC didn't work at all. However, the Oracle ODBC did,
kind
of. The problem is it looks like its corrupting the data about
a
quarterway through the images (Firebird displays the image out of
focus, IE
gives red x).
I've got itembuffersize set to 5mb, and
the files I'm sampling are like
40kb.
Based on the process of
elimination, I'm left with two culprits that could
be causing the
problems, Oracle or WiTango.
Is anybody doing something similar (with
Oracle, Apache 2.0, Windows, and
WiTango 5.0) and have it working
perfectly, even if its not necessarily
jpegs, but some other binary data?
Or any insight? I really need to make
this code work... (we're migrating
to storing the images in the filesystem,
but we can't do that yet because
of factors outside our power).
Thanks!
Jonah
Simpson ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
|
