Ubuntu ODBC MySQL 8 OPTION 无效

因FreeSWITCH使用ODBC需求，出现错误

If you are using mysql, make sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS

# vim /etc/odbc.ini
[freeswitch]
Driver = MySQL
SERVER = localhost
PORT = 3306
DATABASE = myDatabase
OPTION = 67108864

注意：option = 67108864  开启sql批处理，FreeSWITCH  ODBC模式必须开启

ODBC未配置SQL 预处理，引起同时执行多条SQL语句时报错

ubuntu20.04

从MySql官网下载安装ODBC驱动

注意8X的版本option设置后都无效，

解决办法降级

mysql-connector-odbc-5.3.14-linux-ubuntu19.10-x86-64bit.tar.gz

验证支持预处理方法，关于odbc配置这里不在说明

isql -v freeswitch

delete from sip_registrations where sub_host is null and hostname='VM-0-13-ubuntu' and network_ip like '%' and network_port like '%