<!-- This comment will put IE 6, 7 and 8 in quirks mode -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>FreeTDS API: Conversion</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javaScript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body onload='searchBox.OnSelectItem(0);'>
<!-- Generated by Doxygen 1.6.3 -->
<script type="text/javascript"><!--
var searchBox = new SearchBox("searchBox", "search",false,'Search');
--></script>
<div class="navigation" id="top">
<div class="tabs">
<ul>
<li><a href="index.html"><span>Main Page</span></a></li>
<li><a href="pages.html"><span>Related Pages</span></a></li>
<li><a href="modules.html"><span>Modules</span></a></li>
<li><a href="annotated.html"><span>Classes</span></a></li>
<li><a href="files.html"><span>Files</span></a></li>
<li>
<div id="MSearchBox" class="MSearchBoxInactive">
<img id="MSearchSelect" src="search/search.png"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
alt=""/>
<input type="text" id="MSearchField" value="Search" accesskey="S"
onfocus="searchBox.OnSearchFieldFocus(true)"
onblur="searchBox.OnSearchFieldFocus(false)"
onkeyup="searchBox.OnSearchFieldChange(event)"/>
<a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
</div>
</li>
</ul>
</div>
</div>
<div class="contents">
<h1>Conversion<br/>
<small>
[<a class="el" href="a00305.html">LibTDS API</a>]</small>
</h1>
<p>Conversions between datatypes.
<a href="#_details">More...</a></p>
<table border="0" cellpadding="0" cellspacing="0">
<tr><td colspan="2"><h2>Defines</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga42702d374d9ddaad7208558adc0760c0"></a><!-- doxytag: member="convert::binary_to_result" ref="ga42702d374d9ddaad7208558adc0760c0" args="(data, len, cr)" -->
#define </td><td class="memItemRight" valign="bottom"><b>binary_to_result</b>(data, len, cr) binary_to_result(desttype, data, len, cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gafcdd5a3d01074f486aacfe9f71b8e344"></a><!-- doxytag: member="convert::CASE_ALL_BINARY" ref="gafcdd5a3d01074f486aacfe9f71b8e344" args="" -->
#define </td><td class="memItemRight" valign="bottom"><b>CASE_ALL_BINARY</b> SYBBINARY: case SYBVARBINARY: case SYBIMAGE: case XSYBBINARY: case XSYBVARBINARY: case TDS_CONVERT_BINARY</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga7fcdc70024d510e4d2afd5dd279b75ba"></a><!-- doxytag: member="convert::CASE_ALL_CHAR" ref="ga7fcdc70024d510e4d2afd5dd279b75ba" args="" -->
#define </td><td class="memItemRight" valign="bottom"><b>CASE_ALL_CHAR</b> SYBCHAR: case SYBVARCHAR: case SYBTEXT: case XSYBCHAR: case XSYBVARCHAR</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gaa48dec798d8229afb9d9fdf00798365b"></a><!-- doxytag: member="convert::is_monthname" ref="gaa48dec798d8229afb9d9fdf00798365b" args="(s)" -->
#define </td><td class="memItemRight" valign="bottom"><b>is_monthname</b>(s) (store_monthname(s, NULL) >= 0)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga0febf32b4f92a6171b71efe967a5ee93"></a><!-- doxytag: member="convert::string_to_result" ref="ga0febf32b4f92a6171b71efe967a5ee93" args="(s, cr)" -->
#define </td><td class="memItemRight" valign="bottom"><b>string_to_result</b>(s, cr) string_to_result(desttype, s, cr)</td></tr>
<tr><td colspan="2"><h2>Functions</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gab09f8279ad6da8a0a6a935e5810d753a"></a><!-- doxytag: member="convert::binary_to_result" ref="gab09f8279ad6da8a0a6a935e5810d753a" args="(int desttype, const void *data, size_t len, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#gab09f8279ad6da8a0a6a935e5810d753a">binary_to_result</a> (int desttype, const void *data, size_t len, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Copy binary data to to result and return len or TDS_CONVERT_NOMEM. <br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gaba21c13b588726927afe423a9c3b5e2d"></a><!-- doxytag: member="convert::is_alphabetic" ref="gaba21c13b588726927afe423a9c3b5e2d" args="(const char *)" -->
static int </td><td class="memItemRight" valign="bottom"><b>is_alphabetic</b> (const char *)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gae6666f5162a337cd5097e514d4559489"></a><!-- doxytag: member="convert::is_ampm" ref="gae6666f5162a337cd5097e514d4559489" args="(const char *)" -->
static int </td><td class="memItemRight" valign="bottom"><b>is_ampm</b> (const char *)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga9b8f105e063d73cb63eb427f66736cfe"></a><!-- doxytag: member="convert::is_dd_mon_yyyy" ref="ga9b8f105e063d73cb63eb427f66736cfe" args="(char *t)" -->
static int </td><td class="memItemRight" valign="bottom"><b>is_dd_mon_yyyy</b> (char *t)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gabeeffbbcaaee26f44cf9901898a42921"></a><!-- doxytag: member="convert::is_numeric" ref="gabeeffbbcaaee26f44cf9901898a42921" args="(const char *)" -->
static int </td><td class="memItemRight" valign="bottom"><b>is_numeric</b> (const char *)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga10c58eea20a424925f293e98c1041389"></a><!-- doxytag: member="convert::is_numeric_dateformat" ref="ga10c58eea20a424925f293e98c1041389" args="(const char *)" -->
static int </td><td class="memItemRight" valign="bottom"><b>is_numeric_dateformat</b> (const char *)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga5eebce05b9f47324d2cfdcbb0dfa8f22"></a><!-- doxytag: member="convert::is_timeformat" ref="ga5eebce05b9f47324d2cfdcbb0dfa8f22" args="(const char *)" -->
static int </td><td class="memItemRight" valign="bottom"><b>is_timeformat</b> (const char *)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gab8994f5451abc18c77943498f9c80759"></a><!-- doxytag: member="convert::store_dd_mon_yyy_date" ref="gab8994f5451abc18c77943498f9c80759" args="(char *datestr, struct tds_time *t)" -->
static int </td><td class="memItemRight" valign="bottom"><b>store_dd_mon_yyy_date</b> (char *datestr, struct <a class="el" href="a00124.html">tds_time</a> *t)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gacc60323e8c3baf5e5534172e7c5c4dee"></a><!-- doxytag: member="convert::store_hour" ref="gacc60323e8c3baf5e5534172e7c5c4dee" args="(const char *, const char *, struct tds_time *)" -->
static int </td><td class="memItemRight" valign="bottom"><b>store_hour</b> (const char *, const char *, struct <a class="el" href="a00124.html">tds_time</a> *)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gaf995695a22d8e1444d4a7efcb1dee566"></a><!-- doxytag: member="convert::store_mday" ref="gaf995695a22d8e1444d4a7efcb1dee566" args="(const char *, struct tds_time *)" -->
static int </td><td class="memItemRight" valign="bottom"><b>store_mday</b> (const char *, struct <a class="el" href="a00124.html">tds_time</a> *)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static int </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#ga17a0597ec3522c7f1ddb54956226dbfc">store_monthname</a> (const char *datestr, struct <a class="el" href="a00124.html">tds_time</a> *t)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Test if a string is a month name and store correct month number. <a href="#ga17a0597ec3522c7f1ddb54956226dbfc"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gaf352a92c0e0558fb30323d5597472df4"></a><!-- doxytag: member="convert::store_numeric_date" ref="gaf352a92c0e0558fb30323d5597472df4" args="(const char *, struct tds_time *)" -->
static int </td><td class="memItemRight" valign="bottom"><b>store_numeric_date</b> (const char *, struct <a class="el" href="a00124.html">tds_time</a> *)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga29589f8426e490f512d5ccd8c8420f88"></a><!-- doxytag: member="convert::store_time" ref="ga29589f8426e490f512d5ccd8c8420f88" args="(const char *, struct tds_time *)" -->
static int </td><td class="memItemRight" valign="bottom"><b>store_time</b> (const char *, struct <a class="el" href="a00124.html">tds_time</a> *)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga7049b867ee14d44f7fb4c2dc867d8e8d"></a><!-- doxytag: member="convert::store_year" ref="ga7049b867ee14d44f7fb4c2dc867d8e8d" args="(int, struct tds_time *)" -->
static int </td><td class="memItemRight" valign="bottom"><b>store_year</b> (int, struct <a class="el" href="a00124.html">tds_time</a> *)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga7a69efda2c2a28331b2aecfb22fc92c8"></a><!-- doxytag: member="convert::store_yymmdd_date" ref="ga7a69efda2c2a28331b2aecfb22fc92c8" args="(const char *, struct tds_time *)" -->
static int </td><td class="memItemRight" valign="bottom"><b>store_yymmdd_date</b> (const char *, struct <a class="el" href="a00124.html">tds_time</a> *)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga9e4cfc4660ffc1026280b77fbc45c475"></a><!-- doxytag: member="convert::string_to_datetime" ref="ga9e4cfc4660ffc1026280b77fbc45c475" args="(const char *datestr, int desttype, CONV_RESULT *cr)" -->
static int </td><td class="memItemRight" valign="bottom"><b>string_to_datetime</b> (const char *datestr, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static TDS_INT </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#ga0176fafd412b5b8005bf1202fbc13b00">string_to_int</a> (const char *buf, const char *pend, TDS_INT *res)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">convert a number in string to TDS_INT <a href="#ga0176fafd412b5b8005bf1202fbc13b00"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static TDS_INT </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#ga933f87cca76156648e91f472650b98f3">string_to_int8</a> (const char *buf, const char *pend, TDS_INT8 *res)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">convert a number in string to TDS_INT8 <a href="#ga933f87cca76156648e91f472650b98f3"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static int </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#ga28c75aff2615032005257af7455ed70d">string_to_numeric</a> (const char *instr, const char *pend, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">convert a number in string to a TDSNUMERIC <a href="#ga28c75aff2615032005257af7455ed70d"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga46a5a00dfa70cad4a02d7cc73b314c31"></a><!-- doxytag: member="convert::string_to_result" ref="ga46a5a00dfa70cad4a02d7cc73b314c31" args="(int desttype, const char *s, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#ga46a5a00dfa70cad4a02d7cc73b314c31">string_to_result</a> (int desttype, const char *s, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Copy a terminated string to result and return len or TDS_CONVERT_NOMEM. <br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static int </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#ga467401163bf05ed167f7b2b7e8bd875a">stringz_to_numeric</a> (const char *instr, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">convert a zero terminated string to NUMERIC <a href="#ga467401163bf05ed167f7b2b7e8bd875a"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gad4a41049dddd1aa77ba7ddcd74f2b12c"></a><!-- doxytag: member="convert::tds_char2hex" ref="gad4a41049dddd1aa77ba7ddcd74f2b12c" args="(TDS_CHAR *dest, TDS_UINT destlen, const TDS_CHAR *src, TDS_UINT srclen)" -->
TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_char2hex</b> (TDS_CHAR *dest, TDS_UINT destlen, const TDS_CHAR *src, TDS_UINT srclen)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">TDS_INT </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#gaa865e08f7ad70ef92b111c2ea3657457">tds_convert</a> (const <a class="el" href="a00095.html">TDSCONTEXT</a> *tds_ctx, int srctype, const TDS_CHAR *src, TDS_UINT srclen, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">tds_convert convert a type to another. <a href="#gaa865e08f7ad70ef92b111c2ea3657457"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga4320b140d70d478ffbe4534732c00776"></a><!-- doxytag: member="convert::tds_convert_binary" ref="ga4320b140d70d478ffbe4534732c00776" args="(int srctype, const TDS_UCHAR *src, TDS_INT srclen, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_binary</b> (int srctype, const TDS_UCHAR *src, TDS_INT srclen, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gab8bbc8f0988073045a4a298e85083d7d"></a><!-- doxytag: member="convert::tds_convert_bit" ref="gab8bbc8f0988073045a4a298e85083d7d" args="(int srctype, const TDS_CHAR *src, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_bit</b> (int srctype, const TDS_CHAR *src, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga6748ea8223b36155dd5141572a3b4368"></a><!-- doxytag: member="convert::tds_convert_char" ref="ga6748ea8223b36155dd5141572a3b4368" args="(int srctype, const TDS_CHAR *src, TDS_UINT srclen, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_char</b> (int srctype, const TDS_CHAR *src, TDS_UINT srclen, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga9de76766fdc4c3064390cf1ef31279e2"></a><!-- doxytag: member="convert::tds_convert_datetime" ref="ga9de76766fdc4c3064390cf1ef31279e2" args="(const TDSCONTEXT *tds_ctx, int srctype, const TDS_CHAR *src, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_datetime</b> (const <a class="el" href="a00095.html">TDSCONTEXT</a> *tds_ctx, int srctype, const TDS_CHAR *src, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gac25afbb137552296e7c2d032e6b9b0af"></a><!-- doxytag: member="convert::tds_convert_datetime4" ref="gac25afbb137552296e7c2d032e6b9b0af" args="(const TDSCONTEXT *tds_ctx, int srctype, const TDS_CHAR *src, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_datetime4</b> (const <a class="el" href="a00095.html">TDSCONTEXT</a> *tds_ctx, int srctype, const TDS_CHAR *src, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga3d2ecf903d9113521cd1f993161b38c4"></a><!-- doxytag: member="convert::tds_convert_flt8" ref="ga3d2ecf903d9113521cd1f993161b38c4" args="(int srctype, const TDS_CHAR *src, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_flt8</b> (int srctype, const TDS_CHAR *src, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gae15ccd322f9d84691446b50cac6faab0"></a><!-- doxytag: member="convert::tds_convert_int1" ref="gae15ccd322f9d84691446b50cac6faab0" args="(int srctype, const TDS_CHAR *src, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_int1</b> (int srctype, const TDS_CHAR *src, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga86e7c8428b63840cdacc8babb1acfa16"></a><!-- doxytag: member="convert::tds_convert_int2" ref="ga86e7c8428b63840cdacc8babb1acfa16" args="(int srctype, const TDS_CHAR *src, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_int2</b> (int srctype, const TDS_CHAR *src, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga733c6e1411bf20c9ffd5f8254b2dae74"></a><!-- doxytag: member="convert::tds_convert_int4" ref="ga733c6e1411bf20c9ffd5f8254b2dae74" args="(int srctype, const TDS_CHAR *src, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_int4</b> (int srctype, const TDS_CHAR *src, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gab4868923a8d89a73aa241ba6348ded22"></a><!-- doxytag: member="convert::tds_convert_int8" ref="gab4868923a8d89a73aa241ba6348ded22" args="(int srctype, const TDS_CHAR *src, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_int8</b> (int srctype, const TDS_CHAR *src, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gae89262416d8b6b0f96f9e5382ce8e3e3"></a><!-- doxytag: member="convert::tds_convert_money" ref="gae89262416d8b6b0f96f9e5382ce8e3e3" args="(int srctype, const TDS_CHAR *src, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_money</b> (int srctype, const TDS_CHAR *src, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gad541e691b64e3cc987ef20a058f3eb54"></a><!-- doxytag: member="convert::tds_convert_money4" ref="gad541e691b64e3cc987ef20a058f3eb54" args="(int srctype, const TDS_CHAR *src, int srclen, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_money4</b> (int srctype, const TDS_CHAR *src, int srclen, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gad10e516a2d16885e9a0b4fdc2743f6bc"></a><!-- doxytag: member="convert::tds_convert_numeric" ref="gad10e516a2d16885e9a0b4fdc2743f6bc" args="(int srctype, const TDS_NUMERIC *src, TDS_INT srclen, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_numeric</b> (int srctype, const <a class="el" href="a00133.html">TDS_NUMERIC</a> *src, TDS_INT srclen, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gaa4e0e9c344e11e75970f8555a4b09fdd"></a><!-- doxytag: member="convert::tds_convert_real" ref="gaa4e0e9c344e11e75970f8555a4b09fdd" args="(int srctype, const TDS_CHAR *src, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_real</b> (int srctype, const TDS_CHAR *src, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="gab44c33a0cba272645aa29634b7719054"></a><!-- doxytag: member="convert::tds_convert_unique" ref="gab44c33a0cba272645aa29634b7719054" args="(int srctype, const TDS_CHAR *src, TDS_INT srclen, int desttype, CONV_RESULT *cr)" -->
static TDS_INT </td><td class="memItemRight" valign="bottom"><b>tds_convert_unique</b> (int srctype, const TDS_CHAR *src, TDS_INT srclen, int desttype, <a class="el" href="a00049.html">CONV_RESULT</a> *cr)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">TDS_INT </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#gac275bf57990faed7bbf36f3e8c91fe20">tds_datecrack</a> (TDS_INT datetype, const void *di, <a class="el" href="a00127.html">TDSDATEREC</a> *dr)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Convert from db date format to a structured date format. <a href="#gac275bf57990faed7bbf36f3e8c91fe20"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">TDS_INT </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#ga6dcfbe18065674e604b151145394b251">tds_get_null_type</a> (int srctype)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Get same type but nullable. <a href="#ga6dcfbe18065674e604b151145394b251"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">size_t </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#ga22845c9c320ac5e6f306c711cc755e94">tds_strftime</a> (char *buf, size_t maxsize, const char *format, const <a class="el" href="a00127.html">TDSDATEREC</a> *dr)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">format a date string according to an "extended" strftime(3) formatting definition. <a href="#ga22845c9c320ac5e6f306c711cc755e94"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">unsigned char </td><td class="memItemRight" valign="bottom"><a class="el" href="a00298.html#ga80487b313213f60d8be71a50a002bb2c">tds_willconvert</a> (int srctype, int desttype)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Test if a conversion is possible. <a href="#ga80487b313213f60d8be71a50a002bb2c"></a><br/></td></tr>
<tr><td colspan="2"><h2>Variables</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ga2b398cb554e14cd7f58b20479fea8e2b"></a><!-- doxytag: member="convert::tds_hex_digits" ref="ga2b398cb554e14cd7f58b20479fea8e2b" args="[16]" -->
const char </td><td class="memItemRight" valign="bottom"><b>tds_hex_digits</b> [16] = "0123456789abcdef"</td></tr>
</table>
<hr/><a name="_details"></a><h2>Detailed Description</h2>
<p>Conversions between datatypes. </p>
<p>Supports, for example, <a class="el" href="a00286.html#ga32eb72f6fb3edb130e59fb3dd0766e7e" title="Convert one datatype to another.">dbconvert()</a>. </p>
<hr/><h2>Function Documentation</h2>
<a class="anchor" id="ga17a0597ec3522c7f1ddb54956226dbfc"></a><!-- doxytag: member="convert.c::store_monthname" ref="ga17a0597ec3522c7f1ddb54956226dbfc" args="(const char *datestr, struct tds_time *t)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">static int store_monthname </td>
<td>(</td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>datestr</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">struct <a class="el" href="a00124.html">tds_time</a> * </td>
<td class="paramname"> <em>t</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [static]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Test if a string is a month name and store correct month number. </p>
<dl class="return"><dt><b>Returns:</b></dt><dd>month number (0-11) or -1 if not match </dd></dl>
<dl><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>datestr</em> </td><td>string to check </td></tr>
<tr><td valign="top"></td><td valign="top"><em>t</em> </td><td>where to store month (if NULL no store is done) </td></tr>
</table>
</dd>
</dl>
</div>
</div>
<a class="anchor" id="ga0176fafd412b5b8005bf1202fbc13b00"></a><!-- doxytag: member="convert.c::string_to_int" ref="ga0176fafd412b5b8005bf1202fbc13b00" args="(const char *buf, const char *pend, TDS_INT *res)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">static TDS_INT string_to_int </td>
<td>(</td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>buf</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>pend</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">TDS_INT * </td>
<td class="paramname"> <em>res</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [static]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>convert a number in string to TDS_INT </p>
<dl class="return"><dt><b>Returns:</b></dt><dd>TDS_CONVERT_* or failure code on error </dd></dl>
<dl class="remark"><dt><b>Remarks:</b></dt><dd>Sybase's char->int conversion tolerates embedded blanks, such that "convert( int, ' - 13 ' )" works. If we find blanks, we copy the string to a temporary buffer, skipping the blanks. We return the results of atoi() with a clean string.</dd></dl>
<p>n.b. it is possible to embed all sorts of non-printable characters, but we only check for spaces. at this time, no one on the project has tested anything else. </p>
</div>
</div>
<a class="anchor" id="ga933f87cca76156648e91f472650b98f3"></a><!-- doxytag: member="convert.c::string_to_int8" ref="ga933f87cca76156648e91f472650b98f3" args="(const char *buf, const char *pend, TDS_INT8 *res)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">static TDS_INT string_to_int8 </td>
<td>(</td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>buf</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>pend</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">TDS_INT8 * </td>
<td class="paramname"> <em>res</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [static]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>convert a number in string to TDS_INT8 </p>
<dl class="return"><dt><b>Returns:</b></dt><dd>TDS_CONVERT_* or failure code on error </dd></dl>
</div>
</div>
<a class="anchor" id="ga28c75aff2615032005257af7455ed70d"></a><!-- doxytag: member="convert.c::string_to_numeric" ref="ga28c75aff2615032005257af7455ed70d" args="(const char *instr, const char *pend, CONV_RESULT *cr)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">static int string_to_numeric </td>
<td>(</td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>instr</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>pend</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"><a class="el" href="a00049.html">CONV_RESULT</a> * </td>
<td class="paramname"> <em>cr</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [static]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>convert a number in string to a TDSNUMERIC </p>
<dl class="return"><dt><b>Returns:</b></dt><dd>sizeof(TDS_NUMERIC) on success, TDS_CONVERT_* failure code on failure </dd></dl>
</div>
</div>
<a class="anchor" id="ga467401163bf05ed167f7b2b7e8bd875a"></a><!-- doxytag: member="convert.c::stringz_to_numeric" ref="ga467401163bf05ed167f7b2b7e8bd875a" args="(const char *instr, CONV_RESULT *cr)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">static int stringz_to_numeric </td>
<td>(</td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>instr</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"><a class="el" href="a00049.html">CONV_RESULT</a> * </td>
<td class="paramname"> <em>cr</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [static]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>convert a zero terminated string to NUMERIC </p>
<dl class="return"><dt><b>Returns:</b></dt><dd>sizeof(TDS_NUMERIC) on success, TDS_CONVERT_* failure code on failure </dd></dl>
</div>
</div>
<a class="anchor" id="gaa865e08f7ad70ef92b111c2ea3657457"></a><!-- doxytag: member="convert.c::tds_convert" ref="gaa865e08f7ad70ef92b111c2ea3657457" args="(const TDSCONTEXT *tds_ctx, int srctype, const TDS_CHAR *src, TDS_UINT srclen, int desttype, CONV_RESULT *cr)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">TDS_INT tds_convert </td>
<td>(</td>
<td class="paramtype">const <a class="el" href="a00095.html">TDSCONTEXT</a> * </td>
<td class="paramname"> <em>tds_ctx</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">int </td>
<td class="paramname"> <em>srctype</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const TDS_CHAR * </td>
<td class="paramname"> <em>src</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">TDS_UINT </td>
<td class="paramname"> <em>srclen</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">int </td>
<td class="paramname"> <em>desttype</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"><a class="el" href="a00049.html">CONV_RESULT</a> * </td>
<td class="paramname"> <em>cr</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>tds_convert convert a type to another. </p>
<p>If you convert to SYBDECIMAL/SYBNUMERIC you MUST initialize precision and scale of cr. Do not expect strings to be zero terminated. Databases support zero inside string. Using strlen may result on data loss or even a segmentation fault. Instead, use memcpy to copy destination using length returned. This function does not handle NULL, srclen should be >0. Client libraries handle NULLs each in their own way. </p>
<dl><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>tds_ctx</em> </td><td>context (used in conversion to data and to return messages) </td></tr>
<tr><td valign="top"></td><td valign="top"><em>srctype</em> </td><td>type of source </td></tr>
<tr><td valign="top"></td><td valign="top"><em>src</em> </td><td>pointer to source data to convert </td></tr>
<tr><td valign="top"></td><td valign="top"><em>srclen</em> </td><td>length in bytes of source (not counting terminator or strings) </td></tr>
<tr><td valign="top"></td><td valign="top"><em>desttype</em> </td><td>type of destination </td></tr>
<tr><td valign="top"></td><td valign="top"><em>cr</em> </td><td>structure to hold result </td></tr>
</table>
</dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd>length of result or TDS_CONVERT_* failure code on failure. All TDS_CONVERT_* constants are <0. </dd></dl>
</div>
</div>
<a class="anchor" id="gac275bf57990faed7bbf36f3e8c91fe20"></a><!-- doxytag: member="convert.c::tds_datecrack" ref="gac275bf57990faed7bbf36f3e8c91fe20" args="(TDS_INT datetype, const void *di, TDSDATEREC *dr)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">TDS_INT tds_datecrack </td>
<td>(</td>
<td class="paramtype">TDS_INT </td>
<td class="paramname"> <em>datetype</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const void * </td>
<td class="paramname"> <em>di</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"><a class="el" href="a00127.html">TDSDATEREC</a> * </td>
<td class="paramname"> <em>dr</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Convert from db date format to a structured date format. </p>
<dl><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>datetype</em> </td><td>source date type. SYBDATETIME or SYBDATETIME4 </td></tr>
<tr><td valign="top"></td><td valign="top"><em>di</em> </td><td>source date </td></tr>
<tr><td valign="top"></td><td valign="top"><em>dr</em> </td><td>destination date </td></tr>
</table>
</dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd>TDS_FAIL or TDS_SUCCEED </dd></dl>
</div>
</div>
<a class="anchor" id="ga6dcfbe18065674e604b151145394b251"></a><!-- doxytag: member="convert.c::tds_get_null_type" ref="ga6dcfbe18065674e604b151145394b251" args="(int srctype)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">TDS_INT tds_get_null_type </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>srctype</em></td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Get same type but nullable. </p>
<dl><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>srctype</em> </td><td>type requires </td></tr>
</table>
</dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd>nullable type </dd></dl>
</div>
</div>
<a class="anchor" id="ga22845c9c320ac5e6f306c711cc755e94"></a><!-- doxytag: member="convert.c::tds_strftime" ref="ga22845c9c320ac5e6f306c711cc755e94" args="(char *buf, size_t maxsize, const char *format, const TDSDATEREC *dr)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">size_t tds_strftime </td>
<td>(</td>
<td class="paramtype">char * </td>
<td class="paramname"> <em>buf</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">size_t </td>
<td class="paramname"> <em>maxsize</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>format</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="el" href="a00127.html">TDSDATEREC</a> * </td>
<td class="paramname"> <em>dr</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>format a date string according to an "extended" strftime(3) formatting definition. </p>
<dl><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>buf</em> </td><td>output buffer </td></tr>
<tr><td valign="top"></td><td valign="top"><em>maxsize</em> </td><td>size of buffer in bytes (space include terminator) </td></tr>
<tr><td valign="top"></td><td valign="top"><em>format</em> </td><td>format string passed to strftime(3), except that z represents milliseconds </td></tr>
<tr><td valign="top"></td><td valign="top"><em>dr</em> </td><td>date to convert </td></tr>
</table>
</dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd>length of string returned, 0 for error </dd></dl>
</div>
</div>
<a class="anchor" id="ga80487b313213f60d8be71a50a002bb2c"></a><!-- doxytag: member="convert.c::tds_willconvert" ref="ga80487b313213f60d8be71a50a002bb2c" args="(int srctype, int desttype)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">unsigned char tds_willconvert </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>srctype</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">int </td>
<td class="paramname"> <em>desttype</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Test if a conversion is possible. </p>
<dl><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>srctype</em> </td><td>source type </td></tr>
<tr><td valign="top"></td><td valign="top"><em>desttype</em> </td><td>destination type </td></tr>
</table>
</dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd>0 if not convertible </dd></dl>
</div>
</div>
</div>
<!--- window showing the filter options -->
<div id="MSearchSelectWindow"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark"> </span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark"> </span>Enumerator</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark"> </span>Defines</a></div>
<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="" frameborder="0"
name="MSearchResults" id="MSearchResults">
</iframe>
</div>
<hr class="footer"/><address style="text-align: right;"><small>Generated on Wed Aug 17 22:22:32 2011 for FreeTDS API by
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.3 </small></address>
</body>
</html>
distrib
>
Mageia
>
5
>
x86_64
>
media
>
core-release
>
by-pkgid
>
13eec89779171a321fe518ddb0e0fec6
>
files
>
224
