Very Computer

by **Eric Meie** » Thu, 18 Jun 1998 04:00:00

Hello all,

I am currently evaluating MS Sql Server and Oracle
as a backend database for an application that we
have just completed the requirements phase for.

I aplogozie for the same old debate type question, but application
needs are somewhat different in areas that I haven't seen discussed
in the news groups, primarliy in the handling of large text elements.

Specifically I would like to hear some opinions concerning the
text handling capabilities of Oracle NT vs Sql Server 7.0 (not MSSQL 6.5).

I have used the text datatype in Sql Server 6.5 and found limited
manipulation
of the datatype, and some issues with corruption. Does anyone have any
idea if SQL Server 7.0 will have something like the VarChar 2k datatype
that Oracle has??

Other Questions:

1 Is Oracle for NT difficult to use, install?
2 Does Oracle for NT get along well with MS Internet Information Server?
Active Server Pages? NT OS?
3 Does anyone have any experiences (good or bad) using large text items with
Oracle NT?

Thanks so much in advance for your assistance.

Eric Meier
Dominion Digital, Inc.

by **Bob Pfeif** » Thu, 18 Jun 1998 04:00:00

Quote:>> Does anyone have any
>>idea if SQL Server 7.0 will have something like the VarChar 2k datatype
>>that Oracle has??

SQL 7 data pages will be 8K and I believe it can handle character data close
to that size.

Quote:>>1 Is Oracle for NT difficult to use, install?

I just had a conversation with one of my colleagues today who said she had a
rough time installing and configuring Oracle on an NT server, I've talked
with other people who have related similar experiences. I have to admit,
I've never done it myself.

Quote:>>2 Does Oracle for NT get along well with MS Internet Information Server?
>>Active Server Pages? NT OS?

Based on helping troubleshoot a web application that combined these
products, no.

Quote:>>3 Does anyone have any experiences (good or bad) using large text items

with
Oracle NT?

No, but generally I'm a proponent of storing things like images and word
processing docs in the file system and referencing their location in the
database. This is how some of the leading document management products do
it and it works very well.

Hope this helps.

--
Bob Pfeiff
MCSD, SQL Server MVP
Spectrum Technology Group, Inc.

by **Hans-Peter Sloo** » Tue, 30 Jun 1998 04:00:00

Quote:> Hello all,

> I am currently evaluating MS Sql Server and Oracle
> as a backend database for an application that we
> have just completed the requirements phase for.

> I aplogozie for the same old debate type question, but application
> needs are somewhat different in areas that I haven't seen discussed
> in the news groups, primarliy in the handling of large text elements.

> Specifically I would like to hear some opinions concerning the
> text handling capabilities of Oracle NT vs Sql Server 7.0 (not MSSQL
6.5).

> I have used the text datatype in Sql Server 6.5 and found limited
> manipulation
> of the datatype, and some issues with corruption. Does anyone have any
> idea if SQL Server 7.0 will have something like the VarChar 2k datatype
> that Oracle has??

> Other Questions:

> 1 Is Oracle for NT difficult to use, install?

I experience in installing both (Oracle and SQLServer).
Installing Oracle is not more difficult than installing SQLServer.

- Show quoted text -

> 2 Does Oracle for NT get along well with MS Internet Information Server?
> Active Server Pages? NT OS?
> 3 Does anyone have any experiences (good or bad) using large text items
with
> Oracle NT?

> Thanks so much in advance for your assistance.

> Eric Meier
> Dominion Digital, Inc.

by **Tony Lavell** » Wed, 01 Jul 1998 04:00:00

Quote:>Specifically I would like to hear some opinions concerning the
>text handling capabilities of Oracle NT vs Sql Server 7.0 (not MSSQL 6.5).
>2 Does Oracle for NT get along well with MS Internet Information Server?
> Active Server Pages? NT OS?

Visual Studio and "Visual" InterDev (for developing ASP) work best with
SQL Server. There's a wonderful database tool for altering tables. it
creates and runs script to overcome SQL Server's limitations on changes
to tables. I think VID 6 will have better facilities for Orable.

Quote:>3 Does anyone have any experiences (good or bad) using large text items with
>Oracle NT?

BAD. a) only one LONG VARCHAR per table.
b) No Oracle SQL operators/functions (eg LIKE) to search them.
--
Tony Lavelle
Hyrax Computer Systems Ltd, UK
(remove .spamtrap from return address before replying)

by **Roald van Geleuke** » Tue, 07 Jul 1998 04:00:00

Oracle does have limited support for large text fields, but from what I've
heard SQL-server might cause problems when database size exceeds 4-5 Gb. No
first hand experience though......

>>Specifically I would like to hear some opinions concerning the
>>text handling capabilities of Oracle NT vs Sql Server 7.0 (not MSSQL 6.5).

>>2 Does Oracle for NT get along well with MS Internet Information Server?
>> Active Server Pages? NT OS?
>Visual Studio and "Visual" InterDev (for developing ASP) work best with
>SQL Server. There's a wonderful database tool for altering tables. it
>creates and runs script to overcome SQL Server's limitations on changes
>to tables. I think VID 6 will have better facilities for Orable.

>>3 Does anyone have any experiences (good or bad) using large text items
with
>>Oracle NT?
>BAD. a) only one LONG VARCHAR per table.
> b) No Oracle SQL operators/functions (eg LIKE) to search them.
>--
>Tony Lavelle
>Hyrax Computer Systems Ltd, UK
>(remove .spamtrap from return address before replying)

Very Computer

Oracle NT 7.3 VS MS Sql Server : Text Issues

Oracle NT 7.3 VS MS Sql Server : Text Issues

Oracle NT 7.3 VS MS Sql Server : Text Issues

Oracle NT 7.3 VS MS Sql Server : Text Issues

Oracle NT 7.3 VS MS Sql Server : Text Issues

Oracle NT 7.3 VS MS Sql Server : Text Issues