This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFF7E7.FA8E7F60
Content-Type: text/plain;
charset="iso-8859-1"
Yeah, CLOBs are the way to go. one caveat....only one CLOB or BLOB per
table though :-) So design wisely.
--b
"A product's only late once, but it can suck
forever." -- Ben Spees, Ambrosia Software
--------------------------------------------
Bryan D. Batchelder
Palm Wireless/Internet Application Developer
W: 813.935.7100
W: 813-936-8844 x 423 (after 5:30PM EST)
H: 727-547-1322
M: 727-808-4296
--------------------------------------------
ConnectWise, Inc. (www.ConnectWise.com)
2803 West Busch Blvd, Suite 204
Tampa, FL 33618
--------------------------------------------
-----Original Message-----
From: Mike Amburn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 27, 2000 12:06 PM
To: Cf-Talk
Subject: How do you store WDDX in Oracle?
When we were using MS-SQL7, we had no problem stored serialized WDDX packets
as long text. However, now that we've moved to Oracle, our new DBA is saying
that there is no long text data type in Oracle, and we can't use varchar
because you can only store 4k in varchar.
What data type should be used? CLOB?
-mike
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------_=_NextPart_001_01BFF7E7.FA8E7F60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: How do you store WDDX in Oracle?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Yeah, CLOBs are the way to go. one =
caveat....only one CLOB or BLOB per table though :-) So design =
wisely.</FONT>
</P>
<P><FONT SIZE=3D2>--b</FONT>
</P>
<P><FONT SIZE=3D2>"A product's only late once, but it can =
suck </FONT>
<BR><FONT SIZE=3D2> forever." -- Ben Spees, Ambrosia =
Software</FONT>
<BR><FONT SIZE=3D2>--------------------------------------------</FONT>
<BR><FONT =
SIZE=3D2> =
Bryan D. Batchelder </FONT>
<BR><FONT SIZE=3D2>Palm Wireless/Internet Application Developer</FONT>
<BR><FONT SIZE=3D2>W: 813.935.7100</FONT>
<BR><FONT SIZE=3D2>W: 813-936-8844 x 423 (after 5:30PM EST)</FONT>
<BR><FONT SIZE=3D2>H: 727-547-1322</FONT>
<BR><FONT SIZE=3D2>M: 727-808-4296</FONT>
<BR><FONT SIZE=3D2>--------------------------------------------</FONT>
<BR><FONT SIZE=3D2>ConnectWise, Inc. (www.ConnectWise.com)</FONT>
<BR><FONT SIZE=3D2>2803 West Busch Blvd, Suite 204</FONT>
<BR><FONT SIZE=3D2>Tampa, FL 33618</FONT>
<BR><FONT SIZE=3D2>--------------------------------------------</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Mike Amburn [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>=
]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, July 27, 2000 12:06 PM</FONT>
<BR><FONT SIZE=3D2>To: Cf-Talk</FONT>
<BR><FONT SIZE=3D2>Subject: How do you store WDDX in Oracle?</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>When we were using MS-SQL7, we had no problem stored =
serialized WDDX packets</FONT>
<BR><FONT SIZE=3D2>as long text. However, now that we've moved to =
Oracle, our new DBA is saying</FONT>
<BR><FONT SIZE=3D2>that there is no long text data type in Oracle, and =
we can't use varchar</FONT>
<BR><FONT SIZE=3D2>because you can only store 4k in varchar.</FONT>
</P>
<P><FONT SIZE=3D2>What data type should be used? CLOB?</FONT>
</P>
<P><FONT SIZE=3D2>-mike</FONT>
</P>
<BR>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A></FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01BFF7E7.FA8E7F60--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
