Microsoft SQL Server client for v4 upgrade warning - Version 4 contains many breaking changes, read more in the 3.x to 4.x changes section. Supported TDS drivers: More information about Tedious specific options: 0.12.x or newer. This driver is not part of the default package and must be installed separately by , a new TDS connection is acquired from the pool and reserved for desired action.
Once the action is complete, connection is released back to the pool.
What should happen now is that if your bound parameters are unicode, DBD:: ODBC will bind them as wide characters (unicode) and your driver or database will attempt to convert them into the code page it is using.
This means so long as your database can store the data you are inserting, when you read it back you should get what you inserted. DBD:: ODBC is unlike most other DBDs in that it connects to literally dozens of possible ODBC Drivers.
Set this before execute to "force" DBD:: ODBC to re-obtain the result set's number of columns and column types for each execute.
Especially useful for calling stored procedures which may return different result sets each execute.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
Copyright (c) 2013-2017 Patrik Simek The MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.Also you should use this if you're plan to work with local temporary tables (more information here). NOTE: Table-Valued Parameter (TVP) is not supported in batch. Do not confuse this with the ODBC attributes before creating a statement or explicitly set it on your statement handle.The odbc_query_timeout on a statement is inherited from the parent connection.This attribute requires DBI version 1.55 or better. Example: method with a SQL type this overrides everything else above.