Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What's the Option=N in the MySQL ODBC connection string?

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?

like image 423
hawbsl Avatar asked Dec 10 '10 10:12

hawbsl


People also ask

What is connection string in ODBC?

String. The ODBC driver connection string that includes settings, such as the data source name, needed to establish the initial connection. The default value is an empty string (""). The maximum length is 1024 characters.

What is MySQL connection string?

A connection string is a sequence of variables which will address the specific database and allow you to connect your code to your MySQL database.


1 Answers

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;

like image 93
scatman Avatar answered Oct 22 '22 00:10

scatman