At 21:22 10.07.2003 +1000, you wrote:

>Errm - do you set the correct client character set when connecting via
>IB_SQL? (combobox on the Connection page). If not, then IB_SQL will be
>storing your strings in charset NONE, so the Swedish characters won't give
>you transliteration errors until you try to access them, or the system
>tries to perform a collation on them.

If only it had been that simple. No, I use ISO8859_1 all the way. Though in
the Browse mode of IB_SQL, I do notice that the Source tab reports neither
character set nor collation. I quoted the versions I used in hope of there
having occured a changed between 4.0.2C and 4.2Hi that could have explained
things.

>Otherwise - I have no idea...

Thanks, I'm about to get the idea that I have to go to brookstonesystems
and try to learn how to define my own collation (even though it mentioned
the frightening letter C, which I've so far managed to steer away from
using for the last eleven years). Hopefully, the source for the NO_NO
collation will be available as a starting point.

Set