On 15-7-2016 09:42, Norbert Saint Georges [email protected] [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
