try this
SELECT * FROM TABLE1
ORDER BY STRING_FIELD COLLATE PXW_TURK

----- Original Message -----
From: "naciye_uzun" <naciye_uzun@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, March 04, 2006 10:15 AM
Subject: [firebird-support] Re: turkish character set problem (hellllpp)


> hi,
> I set the character set while connecting to database ,this time I can
> use turkish characters. but I set Collate "none" (because setting it
> to PXW_TURK or WIN1254 causes error.) but when I try to select records
> by ASC (I mean alphabetical order) it dosen't work correctly. Because
> of the turkish characters I can't have a true alphabetical order.
> what is the problem?
> I'm using C# and IBX personel edition.
>
> thank you.
>
>
>
>
>
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>
> __________ NOD32 1.1429 (20060303) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>