I have spent the last two days to find out the solution but not. So, i am trying the Forum for first time.
The problem is when i use the sc_select and try to “echo” a specific field (K_Type) i get the �������� as return which is Greek characters into DB.
If I run the same query into SQL Builder I get the Greek characters correctly.
The php code is
$check_sql = “SELECT TOP 1 K_Callie, K_Date, K_Time, K_Car, K_Type, K_Driver”
. " FROM vResApi"
. " WHERE K_Car = 'KWD439";
echo $rs->fields; //which return the ��������
My Scriptcase version is 9.4.018
Professional Edition Bronze MSSQL
Any suggestion will appreciated.