Subject | RE: [firebird-support] 60 chars in a 50 field |
---|---|
Author | Chad Z. Hower |
Post date | 2005-02-24T18:01:31Z |
:: Through the magic of variable length characters. Firebird's
:: Unicode-FSS
:: (aka UTC-8) checks for a byte-length overflow, but ignores
:: character length overflows. One argument is "If the string
If I have a table that's VarChar 50 - why should it allow more than 50
though? 50 should be 50 chars IMO, not 50 bytes of whatever my Unicode
happens to turn up as. And doesn't the 50 actually turn into 150 because you
use 3 bytes for Unicode anways? Seems quite inconsistent to me.
:: fits in the space, why throw it out?" In the case of our
:: system tables (nominally Unicode-FSS) that's really
:: important or every name would be limited to 10 characters.
I don't need to name my tables using Unicode - just store Unicode data.
:: Unicode-FSS
:: (aka UTC-8) checks for a byte-length overflow, but ignores
:: character length overflows. One argument is "If the string
If I have a table that's VarChar 50 - why should it allow more than 50
though? 50 should be 50 chars IMO, not 50 bytes of whatever my Unicode
happens to turn up as. And doesn't the 50 actually turn into 150 because you
use 3 bytes for Unicode anways? Seems quite inconsistent to me.
:: fits in the space, why throw it out?" In the case of our
:: system tables (nominally Unicode-FSS) that's really
:: important or every name would be limited to 10 characters.
I don't need to name my tables using Unicode - just store Unicode data.