---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 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
>
>
>