https://community.qlik.com/t5/QlikView/Connection-MemSql-problem-with-character/m-p/1860402#M1227603 <P>Hi, i have a problem with a connetion to my db MemSql (i use an odbc MySql driver), in the connection odbc i use the charset: utf8, so i think all is right!</P> <P>But when i take value from Qlik i see that:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="danosoft_1-1637147110691.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66838iC203722FDEFB9002/image-size/medium?v=v2&amp;px=400" role="button" title="danosoft_1-1637147110691.png" alt="danosoft_1-1637147110691.png" /></span></P> <P>as you see i have the strange character... there need characther "à" and not that</P> <P>on the database i see the right value as you look</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="danosoft_2-1637147201563.png" style="width: 447px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66839i95B9E760E9E2CF5D/image-dimensions/447x47?v=v2" width="447" height="47" role="button" title="danosoft_2-1637147201563.png" alt="danosoft_2-1637147201563.png" /></span></P> <P>so why on qlik that is wrong?</P> <P>Those are the details of the connection:</P> <P>ODBC CONNECT TO [SERVER] (XUserId is AGREERGDSDAsdSD);</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="danosoft_0-1637147021637.png" style="width: 338px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66837i66FF169AA4808021/image-dimensions/338x545?v=v2" width="338" height="545" role="button" title="danosoft_0-1637147021637.png" alt="danosoft_0-1637147021637.png" /></span></P> <P>&nbsp;</P> Mon, 26 Jan 2026 21:26:37 GMT danosoft 2026-01-26T21:26:37Z https://community.qlik.com/t5/QlikView/Connection-MemSql-problem-with-character/m-p/1860402#M1227603 <P>Hi, i have a problem with a connetion to my db MemSql (i use an odbc MySql driver), in the connection odbc i use the charset: utf8, so i think all is right!</P> <P>But when i take value from Qlik i see that:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="danosoft_1-1637147110691.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66838iC203722FDEFB9002/image-size/medium?v=v2&amp;px=400" role="button" title="danosoft_1-1637147110691.png" alt="danosoft_1-1637147110691.png" /></span></P> <P>as you see i have the strange character... there need characther "à" and not that</P> <P>on the database i see the right value as you look</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="danosoft_2-1637147201563.png" style="width: 447px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66839i95B9E760E9E2CF5D/image-dimensions/447x47?v=v2" width="447" height="47" role="button" title="danosoft_2-1637147201563.png" alt="danosoft_2-1637147201563.png" /></span></P> <P>so why on qlik that is wrong?</P> <P>Those are the details of the connection:</P> <P>ODBC CONNECT TO [SERVER] (XUserId is AGREERGDSDAsdSD);</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="danosoft_0-1637147021637.png" style="width: 338px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66837i66FF169AA4808021/image-dimensions/338x545?v=v2" width="338" height="545" role="button" title="danosoft_0-1637147021637.png" alt="danosoft_0-1637147021637.png" /></span></P> <P>&nbsp;</P> Mon, 26 Jan 2026 21:26:37 GMT https://community.qlik.com/t5/QlikView/Connection-MemSql-problem-with-character/m-p/1860402#M1227603 danosoft 2026-01-26T21:26:37Z https://community.qlik.com/t5/QlikView/Connection-MemSql-problem-with-character/m-p/1860915#M1227610 <P>I found the solution.</P> <P>I think it's a driver bug "MySql ODBC 3.51" becouse installing the driver "MySql ODBC 8.0 unicode" everything works fine</P> Thu, 18 Nov 2021 11:16:40 GMT https://community.qlik.com/t5/QlikView/Connection-MemSql-problem-with-character/m-p/1860915#M1227610 danosoft 2021-11-18T11:16:40Z