What is the OPTION=3 parameter for in the Database connections?

Asked

Viewed 44 times

2

A database connection 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 in it and there is a list of possible numbers to be used, but you do not have this OPTION 3. I’ve seen other numbers being used in examples on google, but they don’t explain or comment on what the difference is or what it’s for. As 16387, that tb is not in the list cited above.

mysql database odbc

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.

It is possible to check an old version of the documentation on web.archive.org, where:

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

Information Obtained from Stack Overflow here.

  • Thanks, and what would be the best use now? use the standard =0 ? (which in case would not even need to list it)

  • I can’t tell you =/

Browser other questions tagged mysql database odbc

You are not signed in. Login or sign up in order to post.