Subject Re: [Firebird-Java] Re: How to read the content of the trigger!!!
Author Roman Rokytskyy
> But field RDB$TRIGGER_SOURCE is Blod.I haven't tried your code yet.Is
> it Ok or I have to convert it into Java String to display and
> modify.How can I do that?

You can do the following:

Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery(BLOB_SOURCE_SELECT);
if (!rs.next())
throw new SomeException("Could not load source for BLOB");
return new String(rs.getBytes(1));

Alternatively you can supply encoding into String(...) constructor, but that
is not needed, since the source contains only ASCII characters anyway.

Roman