<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi All<br>
<br>
I am trying to log CEL Events to <span class="hps" style="color:
rgb(51, 51, 51); font-family: arial, sans-serif; font-size: 16px;
font-style: normal; font-variant: normal; font-weight: normal;
letter-spacing: normal; line-height: normal; orphans: 2;
text-align: -webkit-auto; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;
background-color: rgb(245, 245, 245); ">mysql through</span><span
style="color: rgb(51, 51, 51); font-family: arial, sans-serif;
font-size: 16px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height: normal;
orphans: 2; text-align: -webkit-auto; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; background-color: rgb(245, 245,
245); display: inline !important; float: none; "><span
class="Apple-converted-space"> </span></span><span class="hps"
style="color: rgb(51, 51, 51); font-family: arial, sans-serif;
font-size: 16px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height: normal;
orphans: 2; text-align: -webkit-auto; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; background-color: rgb(245, 245,
245); ">odbc</span><span class="" style="color: rgb(51, 51, 51);
font-family: arial, sans-serif; font-size: 16px; font-style:
normal; font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: normal; orphans: 2; text-align: -webkit-auto;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; background-color: rgb(245, 245,
245); ">, but I get</span><span style="color: rgb(51, 51, 51);
font-family: arial, sans-serif; font-size: 16px; font-style:
normal; font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: normal; orphans: 2; text-align: -webkit-auto;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; background-color: rgb(245, 245,
245); display: inline !important; float: none; "><span
class="Apple-converted-space"> </span></span><span class="hps"
style="color: rgb(51, 51, 51); font-family: arial, sans-serif;
font-size: 16px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height: normal;
orphans: 2; text-align: -webkit-auto; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; background-color: rgb(245, 245,
245); ">the message</span><span class="" style="color: rgb(51, 51,
51); font-family: arial, sans-serif; font-size: 16px; font-style:
normal; font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: normal; orphans: 2; text-align: -webkit-auto;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; background-color: rgb(245, 245,
245); ">:<br>
<i><br>
<br>
>><br>
</i>Feb 24 18:03:08] WARNING[12915]: cel_odbc.c:699 odbc_log:
Column type -9 (field 'odbcconnection:cel:cid_name') is
unsupported at this time.<i><br>
</i><<<br>
<br>
I think that is a datatype problem, but i cannot solve the
problem. it only happens with char or varchar datatypes:<br>
<br>
My MySQL cel table structure:<br>
<br>
CREATE TABLE `cel` (<br>
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,<br>
`eventtype` VARCHAR(30) NOT NULL,<br>
`eventtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP<br>
ON UPDATE CURRENT_TIMESTAMP,<br>
`userdeftype` VARCHAR(255) NOT NULL,<br>
`cid_name` VARCHAR(80) NOT NULL,<br>
`cid_num` VARCHAR(80) NOT NULL,<br>
`cid_ani` VARCHAR(80) NOT NULL,<br>
`cid_rdnis` VARCHAR(80) NOT NULL,<br>
`cid_dnid` VARCHAR(80) NOT NULL,<br>
`exten` VARCHAR(80) NOT NULL,<br>
`context` VARCHAR(80) NOT NULL,<br>
`channame` VARCHAR(80) NOT NULL,<br>
`appname` VARCHAR(80) NOT NULL,<br>
`appdata` VARCHAR(80) NOT NULL,<br>
`amaflags` INT(11) NOT NULL,<br>
`accountcode` VARCHAR(20) NOT NULL,<br>
`peeraccount` VARCHAR(20) NOT NULL,<br>
`uniqueid` VARCHAR(150) NOT NULL,<br>
`linkedid` VARCHAR(150) NOT NULL,<br>
`userfield` VARCHAR(255) NOT NULL,<br>
`peer` VARCHAR(80) NOT NULL,<br>
UNIQUE KEY `id` (`id`)<br>
)<br>
<br>
<br>
<br>
Thanks in advance¡¡¡<br>
<br>
<br>
</span>
</body>
</html>