Hi,
for conversion from BLOB to string you can use SUBSTRING function

SELECT CAST(SUBSTRING(data FROM 1) AS VARCHAR(40)) FROM ProductTypeData
data is BLOB field.
Slavek



-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of zzotnik
Sent: Tuesday, April 01, 2008 5:09 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Overflow occured during datatype conversion.
Conversion error from string "BLOB"



Hey Woody,

It was included automatically in the code by EMS SQL Manager, the
client program I'm using to manage my DB.

I've tried removing it but it doesn't solve my problem :(

Any more ideas?

Thanks.

> Why are you specifying a segment size? Not sure if that is the

actual

> problem but I would get rid of those designations since you don't
> declare the fields using those sizes.
>
> Woody (TMW)
>

_
.

<http://geo.yahoo.com/serv?s=97359714/grpId=2442406/grpspId=1705115386/msgId
=93281/stime=1207066298/nc1=3848643/nc2=4025373/nc3=4763761>




[Non-text portions of this message have been removed]