|Subject||RE: [firebird-support] SUBSTRING in triggers does not work for UNICODE_FSS ?|
|Author||Svend Meyland Nicolaisen|
> -----Original Message-----I have checked the UNICODE_FSS character set code recently and it is indeed
> From: Martijn Tonies [mailto:m.tonies@...]
> Sent: 14. april 2005 12:59
> To: firstname.lastname@example.org
> 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
> > 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" :-)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.