On 15-7-2016 09:42, Norbert Saint Georges nsg@...
[firebird-support] wrote:

> -CHARACTER SET ISO8859_1 is not installed
> X-Newsreader: MesNews/1.08.05.00
>
> I try to connect embedded mode via master interface with the code
> (Pascal).
> <--
> master := fb_get_master_interface;
> util := master.getUtilInterface;
> st := master.getStatus;
> prov := master.getDispatcher;
> dpb := util.getXpbBuilder(st, IXpbBuilder.DPB, nil, 0);
> dpb.insertInt(st, isc_dpb_page_size, 4 * 1024);
> dpb.insertString(st,isc_dpb_set_db_charset,'ISO8859_1');
> dpb.insertInt(st,isc_dpb_set_db_sql_dialect,3);
> att := prov.attachDatabase(st, DBPath, dpb.getBufferLength(st),
> dpb.getBuffer(st));
> tra := att.startTransaction(st, 0, nil);
> stmt := att.prepare(st, tra, 0,
> 'select * from
> PS_RM_CUST_FROM_ISO2_CP_LANG2(''FI'',''02540'',''FI'')' ,
> 3, IStatement.PREPARE_PREFETCH_METADATA);
> -->
> I get this error message.
> I've forgotten what?
>

Probably not related to the error, but are you sure you want to use
isc_dpb_set_db_charset and not isc_dpb_lc_ctype, same goes for
isc_dpb_set_db_sql_dialect, where you should use isc_dpb_sql_dialect

isc_dpb_page_size, isc_dpb_set_db_sql_dialect and isc_dpb_set_db_charset
are for database creation (or altering for the last two), not for normal
attach.

BTW: I believe "CHARACTER SET ISO8859_1 is not installed" can occur if
you don't have the intl folder in your install.

Mark
--
Mark Rotteveel