[geeklog-devel] geeklog.net on 1.5.0 - and a db problem

[Mark Howard]

Hi Dirk -

Would declaring the fieldtype as TEXT provide data value compatibility?  

While not as cool as it could be, fields of type TEXT are ostensibly
equivalent to VARCHAR, with the following differences:

From: http://dev.mysql.com/doc/refman/5.0/en/blob.html

--- excerpt ---

In most respects, you can regard a BLOB  column as a VARBINARY column that
can be as large as you like. Similarly, you can regard a TEXT column as a
VARCHAR  column. BLOB and TEXT  differ from VARBINARY and VARCHAR in the
following ways:

    *

      There is no trailing-space removal for BLOB and TEXT columns when
values are stored or retrieved. Before MySQL 5.0.3, this differs from
VARBINARY and VARCHAR, for which trailing spaces are removed when values are
stored.

      On comparisons, TEXT is space extended to fit the compared object,
exactly like CHAR and VARCHAR.
    *

      For indexes on BLOB and TEXT columns, you must specify an index prefix
length. For CHAR and VARCHAR, a prefix length is optional. See Section
7.4.3, "Column Indexes".
    *

      BLOB and TEXT columns cannot have DEFAULT values.

LONG and LONG VARCHAR map to the MEDIUMTEXT data type. This is a
compatibility feature. If you use the BINARY attribute with a TEXT data
type, the column is assigned the binary collation of the column character
set.

MySQL Connector/ODBC defines BLOB values as LONGVARBINARY and TEXT values as
LONGVARCHAR.

--- cut here ---

Also - I have this link in my favorite MySQL bookmarks:

http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

Not sure how this approach would applu to MSSQL, it requires additional
research, which doesn't make sense to do if this doesn't work for you in
MySQL.  ;^)

Best regards.

-m

-----Original Message-----
From: geeklog-devel-bounces at lists.geeklog.net
[mailto:geeklog-devel-bounces at lists.geeklog.net] On Behalf Of Dirk Haun
Sent: Sunday, May 25, 2008 5:51 AM
To: geeklog-devel
Subject: [geeklog-devel] geeklog.net on 1.5.0 - and a db problem

So geeklog.net is now running on 1.5.0. Thanks to everyone who helped in
the final spurt during the last few days.

If you notice any problems on geeklog.net, let me know ASAP. Thanks.


I ran into one problem: MySQL complained about the "urlfor" field in
gl_tokens. It's a VARCHAR field and at least in MySQL 4.0, those are
still restricted to 255 characters.

I've patched it in CVS for now. Suggestions on how to proceed?

bye, Dirk


-- 
http://www.geeklog.net/
http://geeklog.info/

_______________________________________________
geeklog-devel mailing list
geeklog-devel at lists.geeklog.net
http://eight.pairlist.net/mailman/listinfo/geeklog-devel