Hi Cavit!

Instant diagnosis of your problem is:
wrong collation given

See below for test.

"Cavit Aladag" <aladag@a...> wrote:
[...]

> I have set the Character Set and Collate to 'DOS857' from IBExpert

but still I got the wrong order. I have tried 'WIN1254' but no change
in result.

> I have checked the table with ISQL but there is a strange situation.

The Turkish characters are replaced by equivalent symbols from the
original ASCII table.
[...]

I'll come back to your question in more detail later.

But please to one test:

Use your console window (you are on Win32, right?).

Set the codepage of the console to 1254 by

chcp 1254

(or better first to 'chcp' alone, and look what's the
default console codepage)

Start ISQL, set the connection charset by
set names WIN1254

Create a new database, having one table with one column
create table t1 (c1 char(10) character set WIN1254 collate PXW_TURK);

Does things start to work right now?

Regards,
Peter Jacobi
Hamburg, Germany

> I have inserted data from ISQL with Turkish characters and tried to

query with 'ORDER BY' but still the same result.

> Is there sth I am missing or is there a problem with the Turkish

char set?

> Regards,
> Cavit Aladag.
>
> [Non-text portions of this message have been removed]