Subject | Re: [Firebird-Architect] Re: A Fresh Look at Collations |
---|---|
Author | Paul Ruizendaal |
Post date | 2010-06-22T18:54:57Z |
>> Would that statement not be equally slow if the column was plain ASCII?I think that this processing overhead is minimal compared to all the other
>
> Slow, yes. Equally, no.
>
> In order to get to 2000th character in ASCII string, you simply point to
> start + 2000bytes. With UTF8, you'd have to read all the bytes and count
> the characters one by one until you reach 2000th.
work that the CPU must do to process such a statement, but I understand
your point now. Thanks!
Paul