"Text" is not valid Oracle datatype

[Mike Coughlan]

"Text" is not valid Oracle datatype for table horde_categories.

Varchar is the best best, but should I make it size (16) (255) or (1024)?

Varchar is very efficient, but it is easier to make it larger if necessary
than to try and reduce the size later.




SQL> CREATE TABLE horde_categories ...

       category_data TEXT null,
                     *
ERROR at line 6:
ORA-00902: invalid datatype



>From jan@horde.org Date: Fri,  7 Dec 2001 16:13:56 +0100
Return-Path: <jan@horde.org>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 63089 invoked from network); 7 Dec 2001 18:07:33 -0000
Received: from mailout04.sul.t-online.com (HELO mailout04.sul.t-online.de) (194.25.134.18)
  by clark.horde.org with SMTP; 7 Dec 2001 18:07:33 -0000
Received: from fwd07.sul.t-online.de 
	by mailout04.sul.t-online.de with smtp 
	id 16CMlE-00065B-05; Fri, 07 Dec 2001 16:18:00 +0100
Received: from linux.wg.de (320034214675-0001@[217.225.43.97]) by fmrl07.sul.t-online.com
	with esmtp id 16CMky-1BLvsWC; Fri, 7 Dec 2001 16:17:44 +0100
Received: from localhost (localhost [127.0.0.1])
	by linux.wg.de (8.11.0/8.11.0/SuSE Linux 8.11.0-0.4) with ESMTP id fB7FDvk09861
	for <imp@lists.horde.org>; Fri, 7 Dec 2001 16:13:57 +0100
Received: from 192.168.60.1 ( [192.168.60.1])
	as user jan@linux by linux.wg.de with HTTP;
	Fri,  7 Dec 2001 16:13:56 +0100
Message-ID: <1007738036.3c10dcb4c251b@linux.wg.de>
Date: Fri,  7 Dec 2001 16:13:56 +0100
From: Jan Schneider <jan@horde.org>
To: imp@lists.horde.org
References: <200112071435.fB7EZqs22237@emunix.emich.edu>
In-Reply-To: <200112071435.fB7EZqs22237@emunix.emich.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 4.0-cvs
X-Sender: 320034214675-0001@t-dialin.net
Subject: Re: [imp] Opening image attachments in horde-2.0 RC-3/imp 3 ?

Zitat von Matt Goebel <goebel@emunix.emich.edu>:

> 
> Hello,
> 
>   Was wondering if I needed to add entries to the imp mime_drivers.php 
> file so that users could click on the image attachments and have them
> open in the browser like int Imp  2.2.7 ?

No, all mime type not listed in mime_drivers.php are sent to the browser 
directly.

Jan.

::::::::::::::::::::::::::::::::::::::::
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax  +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::