I think you need a full backup restore Bug was already fixed in 2.5.2 http://tracker.firebirdsql.org/browse/CORE-3447 http://tracker.firebirdsql.org/browse/CORE-3447
If it doesn't work please install latest Released version and do a full backup restore ---In firebird-support@yahoogroups.com, <mail@...> wrote: Hello, here is the SQL-statement: ------------------------------------------------------- SELECT * from MyTable order by Name collate Unicode_ci ----------------------------------------------------- That's the complete Error message: ------------------------------------------------------ Error: *** IBPP::SQLException *** Context: Statement::Prepare( SELECT * from MyTable order by Name collate Unicode_ci ) Message: isc_dsql_prepare failed SQL Message : -204 Undefined name Engine Code : 335544855 Engine Message : COLLATION UNICODE_CI for CHARACTER SET UTF8 is not installed ------------------------------------------------------ Note: the same statement works unter Windows without problems. in both cases (Windows and Suse-Linux 12.3) I have installed Firebird Classic-Server 2.5.2. best regards Josef Am 14.11.2013 17:39, schrieb Josef Schnieder: > Hello > > I get the error: > 'COLLATION UNICODE_CI for CHARACTER SET UTF8 is not installed' > > I installed the lastest version of Firebird with Yast. > > Is there an idee? > > best regards > Josef Schnieder > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org http://www.firebirdsql.org and click the > Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo Groups Links > > >