New program mysqlaccess
.
CREATE
now supports all ODBC types and
the mSQL
TEXT
type.
All ODBC 2.5 functions are also supported (added
REPEAT
). This provides better
portability.
Added text types TINYTEXT
,
TEXT
, MEDIUMTEXT
and
LONGTEXT
. These are actually
BLOB
types, but all searching is done in
case-insensitive fashion.
All old BLOB
fields are now
TEXT
fields. This only changes that all
searching on strings is done in case-sensitive fashion. You
must do an ALTER TABLE
and change the
datatype to BLOB
if you want to have
tests done in case-sensitive fashion.
Fixed some configure
issues.
Made the locking code a bit safer. Fixed very unlikely deadlock situation.
Fixed a couple of bugs in the range optimizer. Now the new
range benchmark test-select
works.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.