What is the Parameter OPTION = 3 used for Database connections?

2

A connection to the database is usually something like this

Driver=MySQL ODBC 5.1 Driver;Server=XXX;Database=XXX;UID=XXX;PWD=XXX;OPTION=3;

Most google searches suggest this OPTION = 3. In the Mysql manual there is little and has a number of possible numbers to be used, but does not have this OPTION 3. I have already seen other numbers being used in examples in google, but they do not explain or comment on the difference or what it serves. Like 16387, which is not listed above.

    
asked by anonymous 16.08.2018 / 13:23

1 answer

2

The Option= receives a value that identifies the sum of flags that will specify how your ODBC should work, the default value is 0.

You can check an older version of the documentation at web.archive.org , where:

Option=3; is corresponding to FLAG_FIELD_LENGTH (1) + FLAG_FOUND_ROWS (2)

Information Obtained from Stack Overflow here .

    
16.08.2018 / 13:58