Hi Jon:
Sorry I have not express myself clearly. I am not ask do the change in TDK. It is
unreasonable.
I just share the experience with others, how I solve the problem by config turbine.
When somebody met the same problem, he may be interested.
Regards
fanyun
-----Original Message-----
From: Jon Stevens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 11:31 AM
To: Turbine-user
Subject: Re: blob field for oracle
on 5/30/01 6:46 PM, "fanyun" <[EMAIL PROTECTED]> wrote:
> Thanks.
>
> At the end I find that varchar2 can support 4000 characters. It fit my need.
> So I changed the db.prop file for oracle to: blob=varchar2 (2000)
>
> It works. I do not to change the project-schema.xml. Change it in this way,
> we have the flex to move between oracle and mysql.
>
> Regards
>
> fanyun
If you change it to "integer", then you can support any size text or binary
in those fields. For some reason blob == integer with Oracle. The only
downside is that you can't use a "like" query against an integer field. You
have to buy the "Oracle Content Server" in order to do "like" searching
against that column.
-jon
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
