Home > Archive > ASE Database forum > December 2005 > Image Column Search









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Image Column Search
Ashish

2005-12-01, 3:24 am

I have stored a pdf file in the column having image as
datatype.

Now i want to search for a perticular string in that column.

Is it possible to serch perticular string in image datatype
column.

I stored that pdf through java using byte array.

For text datatype "patindex" solves the purpose.

Is there any other methode for image datatype?
Jason L. Froebe [Team Sybase]

2005-12-03, 1:24 pm

Ashish wrote:
> I have stored a pdf file in the column having image as
> datatype.
>
> Now i want to search for a perticular string in that column.
>
> Is it possible to serch perticular string in image datatype
> column.
>
> I stored that pdf through java using byte array.
>
> For text datatype "patindex" solves the purpose.
>
> Is there any other methode for image datatype?



Hi Ashish,

Unfortunately, this can only be done using a java defined function but
this is a feature that requires a separate license. So, yes it is
possible...

Jason L. Froebe
Team Sybase
http://jfroebe.livejournal.com
Ashish

2005-12-05, 3:24 am

> Ashish wrote:
>
>
> Hi Ashish,
>
> Unfortunately, this can only be done using a java defined
> function but this is a feature that requires a separate
> license. So, yes it is possible...
>
> Jason L. Froebe
> Team Sybase
> http://jfroebe.livejournal.com



Can give me some details of this functions?
I mean Syntax of the function or document where I can find
details of this function.

Thank you very much for the Information.

Expecting reply

Regards,
Ashish Khanolkar
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com