FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


PHP question





TGWAdmin
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!!
foggy
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.
simplyw00x
You bascially want a text field, choose tiny, medium or long based on more exact size.
Mgccl
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
shalmoli
Use 'text ' type .
The sizes of tiny, medium and long has already been posted.
landxxx
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
landxxx wrote:
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




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


Question Question Question Question Question
Related topics
php question
JSP and PHP Question
PHP Question
PHP Question
a grouping question?
PHP question, $_SESSION[] gets changes to by $_POST var
PHP Question - Solved
PHP Question: '.../something.php/something_else.png'
Need help with a HTML / PHP question.
A quick PHP Question! You know the answer! Answer ASAP .
Simple PHP question...
O'calhoun's reusable stupid php question thread [NEW]
MySQL and PHP Question
PHP question about passing variables (noob)
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.