E-Books for you

We cannot do this because varchar fields have a maximum size
of 255. The next step is slightly more drastic. We must redefine the field type so as
it will accommodate at least three hundred bytes. Therefore, a varchar(100) field
becomes a text field.
The Database
[ 46 ]
As an example, the core #__content table includes a field named title. For MySQL
severs that support UTF-8, the field is defined as:
'title' varchar(255) NOT NULL default ''
For MyS???L severs that do not support UTF-8, the field is defined as:
'title' text NOT NULL default ''
We should also be aware that using a version of MySQL that does not support UTF-
8 would affect the MySQL string handling functions. For example ordering by a
string field may yield unexpected results. While we can overcome this using postprocessing
in our scripts using the JString class, the recommended resolution is to
upgrade to the latest version of MySQL.
Querying the Database
When we perform a query, we tell the global JDatabase object the query that we
want to execute.


Pages:
52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76