> -----Original Message-----
> From: Martijn Tonies [mailto:m.tonies@...]
> Sent: 14. april 2005 12:59
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] SUBSTRING in triggers does
> not work for UNICODE_FSS ?
>
>
>
> > **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.
>

I have checked the UNICODE_FSS character set code recently and it is indeed
variable.

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

Yes, that would be a good thing. :-) As far as I can see does the INTL
architecture of FireBird offer all the functionality to do this.

/smn