Cyrillic characters desktop version (ok) versus server version (not ok) - same workflow

Hi Everybody! Can anyone help me?

If I use in-db tools to pull down data through desktop version of Alteryx then the cyrillic characters appears perfectly.

But as soon as I upload the workflow to Alteryx server then the cyrillic characters disappear and insted of them small cubes are appear in the exact same workflow.

Why is that? I can only schedule workflow through Alteryx server but in this case the characters became unreadable.

Schedule

In Database

In-Database

Accepted answers

JoeS

Hi @olahnil

That makes sense. Typically with drivers using a later version should be OK,

We list on our site the one that we have done the testing with and support but you should be OK to update your server.

I assume you haven't had any issues with that version locally? Well in fact you have had positives with it 🙂

All comments

JoeS

Hi @olahnil

Are the drivers the same version and set up on your machine and the server?

That'd be the first thing to check.

And the second is a question from me, where is the output that you are comparing these characters?

olahnil

The driver is the same for both server and desktop.

I put 1-1 browser direct after the query of Connect In-DB tool. And at server set up the characters are still wrong.

JoeS

Hi @olahnil

Is the driver the exact same version? Also with the same set up?

Also, is the version of Alteryx the same between the two?

Lastly when you say browser, do you mean a browse in-db tool within designer?

olahnil

Hi Joe,

I investigated and the drivers are different. My driver that works properly: 2.18.04.00. But the server's driver does not able to decode cyrillic 2.16.09.

One solution may be to upgrade the driver version on server however this version is not supported by alteryx so could cause other issues. I raised a ticket to alteryx support. I hope they will find a solution.

Yes, I meant browse-in-db-tool.

JoeS

Hi @olahnil

That makes sense. Typically with drivers using a later version should be OK,

We list on our site the one that we have done the testing with and support but you should be OK to update your server.

I assume you haven't had any issues with that version locally? Well in fact you have had positives with it 🙂

olahnil

Thank you for your answers! I had no issues locally.

Quick Links

This months top contributors

FláviaB 262

caltang 177

DanM 167

IraWatt 157

gawa 157