[quote=189680:@Eli Ott]Send SET NAMES utf8; to the MySQL server after connecting. What you are receiving is probably encoded in Latin-1. Then you can use recSet.field(“Prenom”).StringValue.DefineEncoding(Encodings.UTF8).
The alternative is to use: recSet.field(“Prenom”).StringValue.DefineEncoding(Encodings.ISOLatin1).ConvertEncoding(Encodings.UTF8).[/quote]
Hello Eli,
Unfortunately no help, i did that already and i get something like :
SELECT id FROM contact WHERE firstname = "Agla?©" AND lastname = "AGN?àS" so even more twisted.
i guess the encoding it is not ISOLatin1, its either something else or there is an issue on the encoding from the beginning, the funny part is that on the databases i get the correct data, but on the query it gets that way, or not, it seems that once i put that [code]rdvBase.SQLExecute("set character set utf8")[/code] after the connect i get AGN Agla so wherever its the special character it gets cut, on the other hand if i don`t put the rdvBase.SQLExecute("set character set utf8") i get the correct name in the database but still same strange characters in the query.