Mark Rotteveel wrote: > I am not sure what you mean, but Firebird metadata is already unicode. The question is more 'how' ... I am using Firebird with UTF-8 data already ... via PHP ... but it is all a bit of a bodge due to the way PHP handles things. Processing Unicode data can be fun.
Using ICU with the U_CHARSET_IS_UTF8 flag set at compile time creates a possible clean platform, but I don't think Firebird configures things that way? What I am probably looking towards is things like using LOWER() in Firebird against the same process in PHP. Fun at present when multi-byte characters are involved but if ICU used for both processes then the results do stand a chance of matching :) The discussion expands in PHP to include if function names should be allowed to be UTF-8 strings. I don't see any real problem here except when 'lower' and 'upper' result in different string lengths and I think Firebird is already handling that somehow? FB3 is something I'd like to dovetail into PHP6 cleanly even if I only need to use Unicode for content. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk ------------------------------------------------------------------------------ Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis & security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
