OTL 4.0, Examples for MySQL / MyODBC 3.5

The examples below work with MySQL via MyODBC 3.5. In general, all of these examples should work with any more or less recent versions of  MySQL, when ODBC is enabled in OTL by setting #define OTL_ODBC. For more examples, see the Generic ODBC examples.

  1. Example 225 (Simple Insert/Select/Update, MyODBC 3.50)
  2. Example 226 ("Incompatible datatypes in stream operation" exception, MyODBC 3.50)
  3. Example 227 (otl_datetime container and datetime/date table columns, MyODBC 3.50)
  4. Example 228 (otl_long_string container and LONGTEXT column, MyODBC 3.50)
  5. Example 229 (otl_long_string container and LONGBLOB column, MyODBC 3.50)
  6. Example 230 (std::string and STL-compliant stream iterators, MyODBC 3.50)
  7. Example 231 (otl_stream::describe_select() with a simple Select, MyODBC 3.50)
  8. Example 344  (otl_stream_read_iterator, "get by name" functions, MySQL)
  9. Example 375 (Simple Insert/Select, otl_connect::operator<<, <<=, >>)
  10. Example 382 (Insert/Update/Select, MySQL LONGTEXT in stream mode, and std:strings)
  11. Example 391 (Insert/Update/Select with MySQL LONGTEXT  in stream mode, without otl_lob_stream::set_len())
  12. Example 392 (Insert/Update/Select with  MySQL LONGBLOB in stream mode, without otl_lob_stream::set_len())
  13. Example 452 (Simple Insert/Select with VARBINARY datatype)
  14. Example 453 (Simple Insert/Select with BINARY datatype)
  15. Example 463 (Simple Insert/Select with VARBINARY datatype and otl_stream_read_iterator)
  16. Example 464 (Simple Insert/Select with BINARY datatype and otl_stream_read_iterator)
  17. Example 675 (Simple Insert/Select/Update #define OTL_ODBC_MULTI_MODE)
  18. Example 715 (END-OF_ROW check)
  19. Example 740 (Stored procedure with output parameter)
  20. Example 759 (UTF-8 client encoding)
  21. Example 766 (otl_connect_pool)

Prev NextContentsGo Home

Copyright 1996-2017, Sergei Kuchin, email: skuchin@gmail.com, skuchin@gmail.com .

Permission to use, copy, modify and redistribute this document for any purpose is hereby granted without fee, provided that the above copyright notice appear in all copies. THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.