开发者

double checking my mysql field lengths

开发者 https://www.devze.com 2023-01-13 03:51 出处:网络
I am creating my first serious project in PHP and I want to make sure I have my database setup correctly. It is utf8_general_ci and for example the max I want usernames to be is 20 characters, so the

I am creating my first serious project in PHP and I want to make sure I have my database setup correctly. It is utf8_general_ci and for example the max I want usernames to be is 20 characters, so the username field in the database would be a varchar(20)? Sorry if this is stupid, it is just I r开发者_StackOverflow中文版ead something somewhere that is making me question myself.


Yes you're right:

CREATE DATABASE my_test_db
   DEFAULT CHARACTER SET utf8
   DEFAULT COLLATE utf8_general_ci;
Query OK, 1 row affected (0.00 sec)

USE my_test_db;
Database changed

CREATE TABLE users (username varchar(20));
Query OK, 0 rows affected (0.04 sec)

INSERT INTO users VALUES ('abcdefghijklmnopqrstuvwxyz');
Query OK, 1 row affected, 1 warning (0.00 sec)

SELECT * FROM users;
+----------------------+
| username             |
+----------------------+
| abcdefghijklmnopqrst |
+----------------------+
1 row in set (0.00 sec)
0

精彩评论

暂无评论...
验证码 换一张
取 消