Save 20 random character in mysql

Question

I want save randomly generated 20 character's alpha-numeric in mysql. What type of fields is better choice? varchar, binarym

If you want alpha-numeric values, store them as strings. If they are always 20 characters, use `char(20)`; otherwise `varchar(20)`. — Gordon Linoff, Jan 21 '15 at 12:32

score 0 · Answer 1 · edited May 23 '17 at 12:28

0

The best would be CHAR(20). But if you need to choose between varcher or binary, choose VARCHAR(20).

Here is a discussion how to generate a random string using SQL in case you want the generation to happen in MySQL: Generating a random & unique 8 character string using MySQL

edited May 23 '17 at 12:28

Community

answered Jan 21 '15 at 12:59

Plamen Nikolov

1 Answers1