bi5bo

Finally solved!! 😀 Your function works great. I just had to set the db in utf8 before doing the query. It took me one week to understand it. so: $mysql= _MySQL_Real_Query($MysqlConn, "Set NAMES 'utf8mb4'"); $mysql_bool = _MySQL_Real_Query($MysqlConn, $query) $res = _MySQL_Store_Result($MysqlConn) $row = _MySQL_Fetch_Row_StringArray($res) $path=_CodepageToString($row[2]); Thanks again Jchd !

Strange behaviour. Using MsgBox your function returns the characters as expected. But Scite was switched in utf8. Now i must understand why not return as expected with mysql results.

I have already activated Scite on utf8. I am using mysql 5.6. that supports UTF16, but I've read everywhere it's better to have a UTF8mb4 character set to support all languages. So I changed text fields collation on utf8mb4_general_ci. Since I activated utf8_general_ci I have no longer any errors, inserting filenames.

Hi Jchd, Thank you for your quick reply. Unfortunately, even this function won't return the correct value. ConsoleWrite (_CodepageToString(_StringToCodepage("★"))) The result is: ? I lost a couple of days reading your posts before ask here, and trying out functions like MultibyteToWideChar () and others. The workaround could be to pass the correct string from PHP to autoit, cause the PHP function utf8_decode () function does the job correctly. But I would like to do it in autoit. So I could read the db directly from autoit and make same loops job with it. Any idea?

I have some paths in an sql database utf-8 encoded. I need to convert in a windows correct path. Some dir and file names have japanese or arabic characters and/or symbols. How can i do? i've tried a lot of solutions but no success By example i need to convert this (utf-8): ââââ (In my db field chars are different) in this: ★★★ in php utf8_encode() and utf8_decode() makes the job, but in autoit? Thanks in advance