Recent

Author Topic: Zeos + Mysql 5.1  (Read 3617 times)

Blestan

  • Sr. Member
  • ****
  • Posts: 461
Zeos + Mysql 5.1
« on: February 27, 2012, 09:17:10 pm »
Any Ideas how to enable  mysql compression protocol ( flag MYSQL_CLIENT_COMPRESS) with zeos 7.0 alpha?
Speak postscript or die!
Translate to pdf and live!

paweld

  • Sr. Member
  • ****
  • Posts: 255
Re: Zeos + Mysql 5.1
« Reply #1 on: February 27, 2012, 09:41:20 pm »
zeosdbo/doc/html/parameters.html:
Quote
3. 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 });
Best regards
paweld

Blestan

  • Sr. Member
  • ****
  • Posts: 461
Re: Zeos + Mysql 5.1
« Reply #2 on: February 27, 2012, 09:52:29 pm »
thanks!
Speak postscript or die!
Translate to pdf and live!

 

TinyPortal © 2005-2018