I'm migrating a web application from MySQL to SQL Server. When I use the Enterprise manager to see the imported data everything's fine, but when I select the in a php script the browser show inconsistent characters, i.e. í becomes ¡, ó becomes ¢, ñ becomes ¤, etc.
SQL Server's character set is SQL_Latin1_General_CP1_CI_AS (if that means anything), I've tried changing the browser's character set, but it doesn't help.
Any suggestion on this point would be helpful.
On the other hand, when I inserted data (through php scripts) into the MySQL database I did it in yyy-mm-dd format, logically data retrieval expected that format. Now I get data formats in an english
string format: "Apr 10 2002 12:00AM"
Can I avoid this?
Thank you.
