Subject | Re: [Firebird-Architect] Re: A Fresh Look at Collations |
---|---|
Author | Milan Babuskov |
Post date | 2010-06-22T15:03:46Z |
Hi Paul,
paulruizendaal wrote:
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.
Regards,
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
paulruizendaal wrote:
> Would that statement not be equally slow if the column was plain ASCII?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.
Regards,
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================