Morning all, be gentle with me, I'm not all that good a developer! ;-)
Given the problem with varchars being defined in bytes but needing to store chars, how feasible would it be to allow the definition of a column (or variable) in a manner similar to how Oracle does it? create table ...( a_column varchar(100 char), b_column varchar(100 byte), ...) The default is byte and may be omitted. Whereas the char format guarantees that 100, in this case, characters will be able to fit in the column and is, obviously, dependent on the character set in use. I have no idea if this is standard SQL or not. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767 ------------------------------------------------------------------------------ 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