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
-----Original Message-----
From: Pere Torrodellas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 11:35 PM
To: [EMAIL PROTECTED]
Subject: RE: blob field for oracle
----- Mensaje original -----
De: fanyun <[EMAIL PROTECTED]>
Para: turbine user <[EMAIL PROTECTED]>
Enviado: viernes 25 de mayo de 2001 12:47
Asunto: blob field for oracle
> Hi all:
>
> I have a blob field in database to store a xml file. For mysql, it works
fine, the data will can be read into String for further process.
>
> Now I try to move to oracle. I find the sql statment for blob process is quite
different. Have anyone met this problem?
>
> Regards
>
> fanyun
Hi,
Just in case it helps, we had problems when we migrated a DB to Oracle 8 and
tried to convert LONGRAWs to BLOBs. Stepping back to using LONGRAWs solved our
problems.
Pere Torrodellas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
