Enthaaa Sizeee Isthundiii

[qwerty1204]

CHAR(50) ani Database lo oka column ki datatype set cehsthe..internal storage lo enni bytes allocate avthundi?

does it varies based on different databases aa?

[pandemkodi]

[color=#000000][font=Helvetica, Arial, sans-serif][size=4]in the following [/size][/font][/color][i]M[/i][color=#000000][font=Helvetica, Arial, sans-serif][size=4] represents the declared column length in characters for nonbinary string types and bytes[/size][/font][/color]
Data Type Storage Required CHAR([i]M[/i]) [i]M[/i] × [i]w[/i] bytes, 0 <= [i]M[/i] <= 255, where [i]w[/i] is the number of bytes required for the maximum-length character in the character set

[pandemkodi]

char(50) anuko according to above formula it should be
char(50* W bytes ) where w is hte no of bytes required for the [color=#282828][font=helvetica, arial, sans-serif]maximum-length character in the character set[/font][/color]

[qwerty1204]

[quote name='pandemkodi' timestamp='1352403266' post='1302764968']
[color=#000000][font=Helvetica, Arial, sans-serif][size=4]in the following [/size][/font][/color][i]M[/i][color=#000000][font=Helvetica, Arial, sans-serif][size=4] represents the declared column length in characters for nonbinary string types and bytes[/size][/font][/color]
Data Type Storage Required CHAR([i]M[/i]) [i]M[/i] × [i]w[/i] bytes, 0 <= [i]M[/i] <= 255, where [i]w[/i] is the number of bytes required for the maximum-length character in the character set
[/quote]

akkada w entha anedi ela teluthundi baaa

[qwerty1204]

[quote name='pandemkodi' timestamp='1352403427' post='1302764989']
char(50) anuko according to above formula it should be
char(50* W bytes ) where w is hte [b]no of bytes required for the [color=#282828][font=helvetica, arial, sans-serif]maximum-length character in the character set[/font][/color][/b]
[/quote]

[ChampakDas]

each character saved or kept on heap will take 1 byte mama..now you do the math..
when you are not sure of the allocation of the byte use varchar and then use the allocation length as MAX..so based on the input it will do the job for you..
[quote name='arey ooo samba' timestamp='1352403895' post='1302765044']


[/quote]

[qwerty1204]

[quote name='GatisKandis' timestamp='1352404641' post='1302765112']
each character saved or kept on heap will take 1 byte mama..now you do the math..
when you are not sure of the allocation of the byte use varchar and then use the allocation length as MAX..so based on the input it will do the job for you..
[/quote]

thanx bhayya