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

Reply via email to