Subject Re: [IBO] Ordering in TIB_QUERY
Author Jan Turner
You have to select the proper characterset in the collation property of the
database field on the server. Also your database connection needs a
character set that knows your special characters.

hope this helps.
Turner

"L'Attila" <ludati@...> schrieb im Newsbeitrag
news:3CF4EFFE.8000003@......
> Hi All!
>
> In hungarian ABC there is some special character, for example the good
> order is: ...NOSVO"P...
> I've got an IB_QUERY. When I wrote a SELECT statement into IB_QUERY's
> SQL-property with OrderingItems , it orders fine (...NOSVO"P...).
> But I had to write this statement into stored procedure, and IB_QUERY's
> SQL only select from this procedure. It's faster, but when I add
> OrderingItem on a stringfield, it does not order well, it's doing:
> ...NOP...ZVO"... Stored proc is good, it orders fine, but if I want to
> seek in a grid on this IB_QUERY, I have to define OrderingItem.
>
> Any idea?
>
> Thanks in advance:
> L'Attila
>
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>