What does VARCHAR(20*4) mean?

Question

Referring to this link:

They list some mappings as:

VARCHAR(20*4) VARCHAR(size*4)

I assume they didn't mean VARCHAR(80) for 20*4 or they would have put that?

Any insights would be helpful.

Thank you

Maybe they want to put in 20 things of length 4? – Gordon Linoff Feb 07 '18 at 02:35 — Gordon Linoff, Feb 07 '18 at 02:35
That means 4 is the **maximum bytes per character**. – John Woo Feb 07 '18 at 02:38 — John Woo, Feb 07 '18 at 02:38

score 1 · Accepted Answer · answered Feb 07 '18 at 02:44

The mappings are like:

MySql          Redshift
-------------  ---------------
VARCHAR(size)  VARCHAR(size*4)

meaning that if you have VARCHAR(20) in MySql you need VARCHAR(80) in Redshift.

1 Answers1