Marc Leclerc

> I have been wordering how do deal with different settings to order CHAR
> fields with different language settings. As I looked at many database

design

> the CharSet and collation are embedded into the database. The application

I

> want to port to IB was design with Paradox and got some users unhappy

about

> sorting (Accents, Upper/Lower). It's interface can be used in both french
> and english and maybe more in the future using IB. Would anyone have
> pointers on character set to use and how to deal with this. Can the
> collation be overridden in the application on the fly, etc.

If understand from your message your problem is that users want non case
sensitive order by? If that is the case you could simply have another field
uperrcased and use it for ordering without case sensitivity (in ibo you can
set a
field as case insensitive by giving it the uppercased equivalent). As about
collations
i can't help you there, sorry.

I hope it helps you.

--
Best regards,
Aplication Developer
Pirtea Calin Iancu
S.C. SoftScape S.R.L.
pcalin@...