Another 'klapperich' bug? :)

> > Check your character set/collaton settings for the columns involved.
> >
>
> What should I check exactly ?
> NAME=SANAME=ISO8859_1, DE_DE
> SHORTCUT=ISO8859_1
>
> Even they wouldn't be the same, why works the query with 4K pagesize and

with

> 8K not ?

Does it also happen if you restore your backup to a 4K pagesize database?

I've had some (unexplainable) troubles with views - I had to re-create them
after a backup before I could get them working... Pretty weird, haven't yet
figured out what was wrong and how to reproduce it in a simple case...

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."