On Mon, Sep 02, 2013 at 03:30:26PM +0200, Stefan Heymann wrote: > >>> I'd prefer to have an option to use UTF-16 (treated as a 2-byte > >>> character set with surrogate pairs) as that will only halve the > >>> maximum allowed number of characters. > > The maximum allowed number of characters in Unicode is about 1 > Million. Which can be perfectly represented by either UTF-8 or UTF-16.
If I understood correctly, Mark meant maximum possible length for char() and varchar() types, not the number of characters that can be represented. But as already pointed out, to be able to get to one half of the length available for 8-bit encodings, one would actually have to use UCS-2, not UTF-16. Michal Kubeček ------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel