Zeos + Mysql 5.1
lazarus / 16-Databases

----------------------------------------------------------------------
Blestan · 2012-02-27 20:17

Any Ideas how to enable  mysql compression protocol ( flag
MYSQL_CLIENT_COMPRESS) with zeos 7.0 alpha?

----------------------------------------------------------------------
paweld · 2012-02-27 20:41

zeosdbo/doc/html/parameters.html:
Quote3. MySQL Driver Parameters

3.1. Connection parameters
3.2. Statement parameters

3.1. Connection parameters

    compress=[yes,no] - Turn on/off compression protocol

    dbless=[yes,no] - Connect to the real database or not (dbless
mode)

    useresult=[yes,no] - Fetching rows using UseResult instead
StoreResult.

    timeout=<seconds> - Connection timeout in seconds.

    codepage=<client codepage> - Sets a client codepage. It executes a
SET CHARACTER SET <client codepage> statement righ after connect.
Refer your MySQL server manual for details.

    all mysql_real_connect clientflags are now supported using the
names from the enum type below. (Eg. CLIENT_MULTI_STATEMENTS=TRUE) :

    TMYSQL_CLIENT_OPTIONS =
    ( CLIENT_LONG_PASSWORD,   {  = 1;     { new more secure passwords
}
      CLIENT_FOUND_ROWS ,   {     = 2;     { Found instead of affected
rows }
      CLIENT_LONG_FLAG    ,   { = 4;     { Get all column flags }
      CLIENT_CONNECT_WITH_DB ,   { = 8;     { One can specify db on
connect }
      CLIENT_NO_SCHEMA    ,   {  = 16;     { Don't allow
database.table.column }
      CLIENT_COMPRESS    ,   {  = 32;     { Can use compression
protcol }
      CLIENT_ODBC       ,   {  = 64;     { Odbc client }
      CLIENT_LOCAL_FILES     ,   { = 128;  { Can use LOAD DATA LOCAL }
      CLIENT_IGNORE_SPACE    ,   {  = 256;  { Ignore spaces before '('
}
      CLIENT_CHANGE_USER    ,   {  = 512;  { Support the
mysql_change_user() }
      CLIENT_INTERACTIVE    ,   {  = 1024; { This is an interactive
client }
      CLIENT_SSL     ,   {         = 2048; { Switch to SSL after
handshake }
      CLIENT_IGNORE_SIGPIPE  ,   { = 4096; { IGNORE sigpipes }
      CLIENT_TRANSACTIONS    ,   { = 8196; { Client knows about
transactions }
      CLIENT_RESERVED     ,   {    = 16384; { Old flag for 4.1
protocol  }
      CLIENT_SECURE_CONNECTION  ,   {= 32768; { New 4.1 authentication
}
      CLIENT_MULTI_STATEMENTS  ,   {= 65536; { Enable/disable multi-
stmt support }
      CLIENT_MULTI_RESULTS  ,   {  = 131072; { Enable/disable multi-
results }
      CLIENT_OPT_18,  {2^18 = 262144}
      CLIENT_OPT_19,{2^19 = 524288}
      CLIENT_OPT_20,  {2^20 = 1048576}
      CLIENT_OPT_21,   {2^21 = 2097152 }
      CLIENT_OPT_22,  {2^22 = 4194304}
      CLIENT_OPT_23,  {2^23 = 8388608 }
      CLIENT_OPT_24,   {2^24 = 16777216 }
      CLIENT_OPT_25,   {2^25 = 33554432}
      CLIENT_OPT_26,    {2^26 = 67108864}
      CLIENT_OPT_27,    {2^27 = 134217728}
      CLIENT_OPT_28,    {2^28 = 268435456}
      CLIENT_OPT_29,    {2^29 = 536870912}
      CLIENT_OPT_30,    {2^30 = 1073741824}
      CLIENT_REMEMBER_OPTIONS   { = 2147483648; {Enable/disable multi-
results });

----------------------------------------------------------------------
Blestan · 2012-02-27 20:52

thanks!