Ryan, thank you for your answer.
I think fbintl.dll should have been loaded, since the statements
- SELECT RDB$CHARACTER_SET_NAME, RDB$CHARACTER_SET_ID FROM
RDB$CHARACTER_SETS ORDER BY RDB$CHARACTER_SET_NAME
- SELECT RDB$COLLATION_NAME, RDB$CHARACTER_SET_ID FROM RDB$COLLATIONS
ORDER BY RDB$COLLATION_NAME
show ISO8859_1, 21 in their result.

I have set up the embedded engine as explained in the readme file,
i.e. in the application root dir:
- fbembed.dll
- ib_util.dll
- firebird.msg
- firebird.conf (RootDirectory set)
- intl/fnintl.dll
- udf/fbudf.dll
- jaybird.dll

Regards
Massimo

--- In Firebird-Java@yahoogroups.com, "Ryan Baldwin"
<ryan.baldwin@n...> wrote:

> Hi,
>
> >I can't import data since I continuosly get the following error
> >message and I have no more ideas :)
>
> This is most likley as a result of firebird not being able to load
> fbintl.dll. Sadly when firebird
> cannot find this dll it doesent complain - but often fails too work as
> expected - in this case though it seems
> to have handled the problem in the way that is expected.
>
> The solution is too ensure that fbintl.dll(and for that matter the

entire

> fbembed directory structure) is in the 'correct' place. If using
> fbembedd.dll with jaybird then please check in the forum for posts
> containing the work 'type2' and you should find discussion as too

where this

> directory structure needs too be for jaybird.
>
> Thanks
> Ryan
>
> -----Original Message-----
> From: mapofe [mailto:mapofe@y...]
> Sent: 23 February 2004 11:31
> To: Firebird-Java@yahoogroups.com
> Subject: [Firebird-Java] Charset problem
>
>
> I'm trying to import some data from an access database (sun's
> jdbc-odbc driver) to a firebird embedded (1.5 final) database.
> The embedded database has ISO8859_1 as default charset, I'm using
> ?charSet=iso8859_1 in the connection string.
> I can't import data since I continuosly get the following error
> message and I have no more ideas :)
> Any hints would be appreciated, thank you!
> Massimo
>
> ERROR [DBCExceptionReporter] - could not insert: [InstrumentType#347121]
> org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544321.
> arithmetic exception, numeric overflow, or string truncation
> Implementation of text subtype 21 not located.
> at
>

org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPrepa

> redStatement.java:445)
> at
>

org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPrepare

> dStatement.java:147)
> ...
>
>
>
>
>
>
> Yahoo! Groups Links