Oracle 5.0, Reference Manual

Page: 474 / 3232

Server System Variables
454
Variable Name
group_concat_max_len
Variable Scope Global, Session
Dynamic Variable Yes
Permitted Values
Platform
Bit Size
32
Type
numeric
Default
1024
Range
4 .. 4294967295
Permitted Values
Platform
Bit Size
64
Type
numeric
Default
1024
Range
4 .. 18446744073709547520
The maximum permitted result length in bytes for the
GROUP_CONCAT()
[970] function. The default
is 1024.
•
have_archive
[454]
YES
if
mysqld
supports
ARCHIVE
tables,
NO
if not.
•
have_bdb
[454]
YES
if
mysqld
supports
BDB
tables.
DISABLED
if
--skip-bdb
[420] is used.
•
have_blackhole_engine
[454]
YES
if
mysqld
supports
BLACKHOLE
tables,
NO
if not.
•
have_community_features
[454]
YES
if statement profiling capability is present,
NO
if not. If present, the
profiling
system variable
controls whether this capability is enabled or disabled. See Section 13.7.5.29, “
SHOW PROFILES
Syntax” .
This variable was added in MySQL 5.0.82.
•
have_compress
[454]
YES
if the
zlib
compression library is available to the server,
NO
if not. If not, the
COMPRESS()
[954] and
UNCOMPRESS()
[957] functions cannot be used.
•
have_crypt
[454]
YES
if the
crypt()
system call is available to the server,
NO
if not. If not, the
ENCRYPT()
[955]
function cannot be used.
•
have_csv
[454]
YES
if
mysqld
supports
CSV
tables,
NO
if not.
•
have_example_engine
[454]
YES
if
mysqld
supports
EXAMPLE
tables,
NO
if not.