Browse by Tags

• surrogate

• 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

• What I was doing these days?

  In recent days, I am mainly reading test books since I am a Tester, and I need to know more about testing. The good news for people who are interesting in collation topic is that I will have a SQL Server collation select tool available soon. I hope I Read More... Posted Tuesday, April 07, 2009 6:28 AM by Qingsong Yao | 1 Comments Filed under: collation

• SQL Server’s Binary Collations

  Today, I will discuss SQL Server’s Binary collations. In SQL Server, we have two kinds of binary collations: BIN collation, which has collation name ending with _BIN and BIN2 collation, which has collation name ending with _BIN2. In SQL Server, a string Read More... Posted Tuesday, April 07, 2009 4:55 AM by Qingsong Yao | 1 Comments Filed under: 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

• 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

• 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

• Collation Basic

  In SQL Server, each string type, such as varchar, nvarchar, text, ntext associate with a collation no matter whether you specified or not during creation time. If your app just works fine and you never deal with collation explicitly or you even don't Read More... Posted Friday, January 16, 2009 6:37 AM by Qingsong Yao | 1 Comments Filed under: collation

• SQL Server 2008 (Katmai)'s new collations

  In SQL Server 2008 release, a number of new collations were added. You can get the list of 79 new collations (only _CI_AS was listed) by using select * from fn_helpcollations() where name like '%_100_ci_as' These new collations are aligned with the linguistic Read More... Posted Monday, August 25, 2008 5:33 PM by Qingsong Yao | 1 Comments Filed under: 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