my sql obdc and special characters

[InegiLM]

hello 

i have a program that insert data on a mysql database 

i update mine mysql form the version 5 to 8

After this i update my obdc from 5.3 to 8.0.30.

with this chance some words like "técnico", "Pressão", words with special characters are not accept 

Error: "...Error: 0x80004005
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.30]Incorrect string value: '\xE9cnico...' for column 'Caminho_ficheiro_tabela_velocidades' at row 1..."

i already configure on the obdc configurations the latin1 or utf8mb3 (like the image)

but still get the same error.

how i could to configure this character set on labview

[isabell_L]

Hi,

Did you solve this issue? Or have more information about it?

Thank you in advance!

/Isabel

[Martin_Henz]

I think he was able to solve this with the SET CHARACTER SET Statement 

[InegiLM]

it was much easer that i thoutht .

export your table and you will see that the special characters has been replaced

replace that words with the correct form and create a table with that data and is done

this solve my case