CODEWITHSUNDEEP
mysqlvarchar
user784637
user784637

Reputation: 16092

How to determine amount of bytes in VARCHAR field value?

I have a mysql field with datatype VARCHAR(5) with utf encoding. If I understand correctly field values can hold up to 5 characters and since I'm using utf-8 encoding, a max of 20+1 bytes.

Is there any way I can determine how much space a field value is taking up?

For example I expect the following to take up more than 5 bytes

رروحي

But for this to take up exactly 5 bytes

hello

And for this to take up more than 5 bytes

分別以後才

Upvotes: 1

Views: 1364

Answers (1)

Michael Krelin - hacker
Michael Krelin - hacker

Reputation: 143061

IIRC, mysql has length and char_length functions, so pick the one you need. Obviously, one is supposed to return length in bytes, the other — in characters.

If you want to find it out before it gets to the server side, you need to mention the programming language you use.

Upvotes: 3

Related Questions