I'm creating a table in phpMyAdmin but I don't know what to put for the last input that I will have. I heard that "VARCHAR" takes only 255 characters, but I need much more than that, but I don't know what type to use. I guess you could consider be a newbie at PHP but this is the only question I have for now. THANKS!!
PHP question
All of the string types (tables that store text strings) are defined as follows:
Char - 255 bytes
Varchar - 255 characters
Tiny Blob, Tiny Text - Maximum 200,000,000 byes
Bob, Text - Maximum 20,000,000,000,000,000 byes
Medium Blob, Medium Text - Maximum 2 x 10^24 byes
Long Blob, Long Text - Maximum 2 x 10^32 bytes
Enum - Maximum 2 bytes with a Maximum 65,535 values total
Set - Maxmimum 8 bytes with a Maximum 64 values total
(source)
I hope that this is useful for you. If you also want to learn about the other types besides string, visit the page linked to above.
Char - 255 bytes
Varchar - 255 characters
Tiny Blob, Tiny Text - Maximum 200,000,000 byes
Bob, Text - Maximum 20,000,000,000,000,000 byes
Medium Blob, Medium Text - Maximum 2 x 10^24 byes
Long Blob, Long Text - Maximum 2 x 10^32 bytes
Enum - Maximum 2 bytes with a Maximum 65,535 values total
Set - Maxmimum 8 bytes with a Maximum 64 values total
(source)
I hope that this is useful for you. If you also want to learn about the other types besides string, visit the page linked to above.
You bascially want a text field, choose tiny, medium or long based on more exact size.
some times you don't know the text is enough or not
because if people are using UTF, then everything is 8 times larger
so get to know what encoding you are using first
because if people are using UTF, then everything is 8 times larger
so get to know what encoding you are using first
Use 'text ' type .
The sizes of tiny, medium and long has already been posted.
The sizes of tiny, medium and long has already been posted.
| foggy wrote: |
| All of the string types (tables that store text strings) are defined as follows:
Char - 255 bytes Varchar - 255 characters Tiny Blob, Tiny Text - Maximum 200,000,000 byes Bob, Text - Maximum 20,000,000,000,000,000 byes Medium Blob, Medium Text - Maximum 2 x 10^24 byes Long Blob, Long Text - Maximum 2 x 10^32 bytes Enum - Maximum 2 bytes with a Maximum 65,535 values total Set - Maxmimum 8 bytes with a Maximum 64 values total (source) I hope that this is useful for you. If you also want to learn about the other types besides string, visit the page linked to above. |
but, im MySql base it is not it.
but I will find on internet about MySql and PHP matrix function for good compatible
thank you
| landxxx wrote: | ||
but, im MySql base it is not it. but I will find on internet about MySql and PHP matrix function for good compatible thank you |
eeeeeee,
I have big problem with my private site.
The server don't open page with example index.PHP beacuse index.php
This problem is beacuse server settings or my source code but on mmy computer on apache local host this page open exellent
Related topics
 |