Project Description:
HI,
We need an expert who can assist us with a specific issue with SQL Server. We are using Symfony (Doctrine 1.2), ODBC with SQL Server Native Driver 10 to connect to SQL Server and UTF-8 (For Hebrew data).
The problem is that while the data comes in and is saved back through our Symfony APP, in SQL Server the data looks garbaged, same with ASP.NET pages when we bind it there. We believe it has something to do with proper encoding not being set between Symfony PDO ODBC connection and SQL Server.
This is an urgent requirement. Please see the attached screenshot.