SQL Server gotchas and caveats

I have a project that may require me to use Yii with SQL Server. I’m just wondering if this is going to work. Does anyone know of any gotchas, caveats, or bugs when using Yii with SQL Server?

I’ve used and it works fine. It’s a little ugly with some UTF 8 thing in old versions. But it works ok with 2005 +