I have seen both Option=3 and Option=4 in connection string samples for MySQL ODBC but no explanation or documentation. What do those numbers mean?
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
The Option= value is the sum of the numeric values for various flags that specify how Connector/ODBC should work. Its default value is 0.
From an older version of the Connector/ODBC documentation at web.archive.org:
Option=3; corresponded to FLAG_FIELD_LENGTH (1) + FLAG_FOUND_ROWS (2)
Option=4; was FLAG_DEBUG
According to the current list of Connector/ODBC options here …
Table 5.2 Connector/ODBC Option Parameters
… both FLAG_FIELD_LENGTH (1) and FLAG_DEBUG (4) have been removed.
MySQL also recommends using the parameter names instead of (the sum of) their numeric values, not only for clarity, but because not all options have numeric values. So, instead of
Option=2;
we should use
FOUND_ROWS=1;
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0