Varchar character length

Question

I want to store an unique ID in my MySQL databse, but I need to know how long the X in varchar(X) should be.

The character length I need is 36 characters, example of an unique ID I use: 883db600-3512-4124-8cd5-5bd051f137fe

It seems you're using UUID, so I would use `CHAR(36)` because the length will not change and you'd be storing that data together with the rest of your row data which should improve the performance. — Ja͢ck, Jan 28 '15 at 14:10

score 1 · Accepted Answer · answered Jan 28 '15 at 14:07

1

If it is always 36 characters long then use

char(36)

if it can be shorther then

varchar(36)

answered Jan 28 '15 at 14:07

juergen d

It should always be 36 characters long, I'll use char(36). Thanks – André Mathisen Jan 28 '15 at 14:21

score 0 · Answer 2 · edited May 23 '17 at 11:59

0

A typical guid is 38 bytes (if you are counting the curlies).

char(38) or char(36)

edited May 23 '17 at 11:59

Community

answered Jan 28 '15 at 14:12

T McKeown

2 Answers2