Sql table data type for email address?

Question

What data type I should be using for an email? I just started to learn SQL, and I tried to make some columns, here is my table for ID, Username, Password, Money, and Email.

Did I make it correctly?

Answer 1

Since the max length for an email is 254 characters, I would recommend you to use nvarchar(255). I think that should be enough.

Check out this SQL Tutorial for more insights.

Want to be a SQL expert? Come and join this SQL Certification by Intellipaat.

For more information visit :