I have tried configuring MariabDB Server Character set and Collation to UTF8MB4 & UTF8MB4_UNICODE_CI OR UTF8MB4_GENERAL_CI
[MySQL][ODBC 8.0(a) Driver][mysqld-11.4.2-MariaDB]Incorrect string value: ‘xB2’ for column
itis.mrfmon_tbl.short_descriptionat row 1
here is my connection string:
<code>Dim s As String = "Driver={MySQL ODBC 8.0 ANSI Driver};Server=" & _server & ";Database=itis;User=itams;Password=P@ssw0rd.;CHARSET=UTF8MB4"
</code>
<code>Dim s As String = "Driver={MySQL ODBC 8.0 ANSI Driver};Server=" & _server & ";Database=itis;User=itams;Password=P@ssw0rd.;CHARSET=UTF8MB4"
</code>
Dim s As String = "Driver={MySQL ODBC 8.0 ANSI Driver};Server=" & _server & ";Database=itis;User=itams;Password=P@ssw0rd.;CHARSET=UTF8MB4"
New contributor
user1687496 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.