Well I was just trying to get a length,
you know the size in bytes well storing it in a varchar should yield the same
number of chars as bytes, albeit they will be strange chars ;-) so to you a
select len(varcharfield) from varcharfield.table
Looks like a good one for the people at
With.
Ben Johansen - http://www.pcforge.com
Authorized Witango & MDaemon Reseller
Available for Witango Developement
-----Original Message-----
From: Jonah Simpson
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004
7:01 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk:
uploading images from form into Oracle via different connections [possibly OT]
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.
----- 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.?
Ben Johansen - http://www.pcforge.com
Authorized Witango & MDaemon Reseller
Available for Witango Developement
-----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.
Ben Johansen - http://www.pcforge.com
Authorized Witango & MDaemon Reseller
Available for Witango Developement
-----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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
|
