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 and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo Groups Links > > > ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit 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 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: http://info.yahoo.com/legal/us/yahoo/utos/terms/
