MyBB Community Forums

How much a 1000 characters takes space in database i.e. a 1kb or 100kb etc. And does the characters other than English takes more space? e.g.
⅀

1 character = 1 byte I believe, unless the character set is a multi-byte character set (eg: UTF-8). I could be talking a load of rubbish though.

1 ASCII character = 1 byte
1 UTF-8 Character = 6 bytes to my knowledge

So 1000 characters = 1000 or 6000 bytes

Thanks both of you

1 UTF-8 character is 1 byte for most English characters and general punctuation (it's the exact same as ASCII up to '~' IIRC). For anything else it can take up to 6 bytes. A UTF-16 character can take 2 or 4 bytes IIRC depending on the char. UTF-32 takes 4 bytes always (UTF-8 and UTF-16 decode to UTF-32).

So 1000 characters in typical English will probably take 1000 bytes, plus 1-4 for record-keeping (depending on how the database deals with strings).

Thanks