Browse by Tags

• collation

• Unicode References

  In this article, I recommend several Unicode articles/websites for reference. Note, the list is not yet completed, I will add more entries and make better categorization My blog is a good site for collation issues in SQL Server. Sort it all out . Michael Read More... Posted Wednesday, May 20, 2009 6:00 AM by Qingsong Yao | 1 Comments Filed under: surrogate, collation

• SQL Server and UTF-8 Encoding (1) -True or False

  Today, I will start my series of articles about SQL Server and Unicode UTF-8 Encoding. In many times, I found when people ask me about UTF-8, they actually don't understand UTF-8. So today's talk will be quite short. I just clarify some misunderstand. Read More... Posted Friday, April 10, 2009 6:44 AM by Qingsong Yao | 28 Comments Filed under: surrogate, collation

• 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

• Introduce the Turkish I issue

  Today, I will discuss the famous Turkish I issue. Below is one customer's problem related to Turkish collation? When I use TURKISH_CI_AS collation, some of the field names in the database becomes case-sensitive, as a result queries are returning Invalid Read More... Posted Friday, February 13, 2009 5:34 AM by Qingsong Yao | 1 Comments Filed under: surrogate, collation

• UTF-16 Encoding and SQL Server (1)

  Normal 0 false false false EN-US ZH-CN X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; Read More... Posted Sunday, February 01, 2009 5:25 AM by Qingsong Yao | 4 Comments Filed under: surrogate, collation

• Why should we bother about Surrogate characer?

  Today, someone ask following questions: 1. We know that the Surrogate Characters have two bytes when counting, so when we design this character in DB table, we should set double size of your original type, shouldn't we? 2. When comparing string, if we Read More... Posted Monday, August 11, 2008 8:53 PM by Qingsong Yao | 1 Comments Filed under: surrogate, collation