Problem with Voicemail origtime Field

Comments

• nicolas

  January 2016

  Hi,
  
  I have seen in different setups that field casting in ODBC is "shady". I cannot say for sure, but I have seen many fields being kind of truncated with what appears to be wide characters or utf8 kind of encoding.. something really strange.. Just the other day working on a similar problem, I seend that the id field that is just an integer, was retrieved with this strange chars, ending up truncating the field... like the id was 234234 but the reeturned field was 234^00 (being the last part some kind of wide character or just noise), so it truncated it to 234. Solution in this case was to explicitely cast to char even if its a numeric value and convert the result on the server. Maybe, must maybe, origtime issues you are having is similar/related.
  
  
• wcolling

  February 2016

  The origtime field is defined as varchar(40) with a latin1 character set. Do you think this may be a problem and it should be redefined as datetime or timestamp?
• wcolling

  February 2016

  I did some more checking and I don't think this is related to ODBC. Assuming that FOP2 is written in perl, I wrote the following test program that retrieves the row contents with ODBC.
  
  #!/usr/bin/perl -w
  use strict;
  use DBI;
  my $dbh = DBI-> connect('dbi:ODBC:voicemail');
  
  my $sql = qq/select id, msgnum, dir, context, macrocontext, origtime, duration from voicemail where id='6353'/;
  my $sth = $dbh->prepare($sql) or die "Unable to prepare $sql ".$dbh->errstr;
  
  $sth->execute() or die "Unable to execute query $sql " . $sth->errstr;
  my ($id, $msgnum, $dir, $context, $macrocontext, $origtime, $duration);
  $sth->bind_col(1, \$id);
  $sth->bind_col(2, \$msgnum);
  $sth->bind_col(3, \$dir);
  $sth->bind_col(4, \$context);
  $sth->bind_col(5, \$macrocontext);
  $sth->bind_col(6, \$origtime);
  $sth->bind_col(7, \$duration);
  
  while ($sth->fetch()) {
  print ("$id\t,$msgnum\t,$dir\t,$context\t,$macrocontext\t,$origtime\t,$duration\n");
  }
  $sth->finish();
  $dbh->disconnect();
  
  
  When I ran it, the results were:
  
  6353 ,0 ,/var/spool/asterisk/voicemail/default/4156849813/INBOX ,macro-vm ,ext-local ,1453737132 ,16
  
  which returned the correct values for each field, including the origtime field.
• nicolas

  February 2016

  Problem *is* due to casting to avoid issues with some systems.. in yours cast for that field is returning 1 char out of the whole bunch. I am changing the query to cast char(50) in the hope that it will cast all digits. There is a new binary server file on your test server you can test it out. I think it works fine now.