March 2009 - Posts

• Be aware of comparing unicode constant with varchar column (updated)

  Today, I looked for SQL Server JDBC Driver's sendStringParametersAsUnicode, this parameter controls how Unicode String (Java only have Unicode string which is UTF-16 encoding) will be sending to SQL Server. As the name of this parameter indicate, when Read More... Posted Thursday, March 26, 2009 5:27 AM by Qingsong Yao | 0 Comments Filed under: surrogate, collation

• Is Datetime2 compliant with Daylight Savings Time?

  Today, I got following questions: " The documentation states that Datetime2 is unaware of the time zone. Does that still guarantee that when the clock gets adjusted for Daylight Saving Time this will not result in duplicate timestamps? I.e. is Datetime2 Read More... Posted Thursday, March 12, 2009 6:08 AM by Qingsong Yao | 0 Comments

• Why I write so many collation topics?

  You may wonder why I keep writing collation topics in my blogs. I found our Books Online topics related to collation is not so clearly enough, and sometime it confuse our reader. I intend to present my idea related to collation in a series of blogs, and Read More... Posted Wednesday, March 11, 2009 6:10 AM by Qingsong Yao | 8 Comments Filed under: collation

• Got Collation conflict, How to avoid this?

  The best way to avoid SQL Server's collation conflict issue is that avoid have different collations in your database schema. If your server and database have the same collation, you will never see the conflict collation issue. if all string columns in Read More... Posted Wednesday, March 11, 2009 5:48 AM by Qingsong Yao | 0 Comments Filed under: collation