MySQL charset

Asterisk Asterisk Support
1

Hi
I’m using FreePBX to add CallerID lookup source for asterisk server.
I use an UTF-8 table but when asterisk does the query from that table it doesn’t use UTF-8, so some characters get messed up.

Where do I setup this, so that asterisk queries form dial plan would use utf-8?

Thank you

2

It looks more like settings of MySQL. But - there are commands to set charset per session - just go and look MySQL docs.

3

Default mysql charset is set to utf-8

And if I do a manual query the results are fine…but whet asterisk does the query it seems it uses another charset.