Hi guys,
I use Lazarus 1.6 to connect to SQL Server 2014 using ODBC connection (FileDSN), on Windows 7.
Connection is fine, everything is OK except one problem :
The data in SQL server have been saved in Greek characters (Windows 1253 or ISO-8859-7), not Unicode.
So, when I get the data on a StringGrid (I use ODBCConnection and SQLQuery components to do the job), in the fields that containt Greek characters, I see ????. I used function AnsiToUTF8 or UTF8Encode just in case it could transform the characters but the result was negative.
Could you please give some help on how to solve this ?
Thank you.