Subject Re: [firebird-support] SUBSTRING in triggers does not work for UNICODE_FSS ?
Author Martijn Tonies
> **IF** UNICODE_FSS was fixed at 3 bytes per character then you
> could work around the problem by multiplying your pos and
> length parameters. BUT if UNICODE_FSS is truly variable (as
> I believe it is) then SUBSTRING becomes essentially useless.
> Which is one of the reasons I stopped trying to use it.

Or it should be fixed to take "characters" instead of "bytes" :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions