February 2009 - Posts

• GB18030 Character Set Support in SQL Server

  Recently, I got several request related to GB18030 Character Set support in SQL Server. Here is one of the requests: When I try to insert different combination of GB18030 characters in to a varchar column, it gives me unique constraint violation error. Read More... Posted Tuesday, February 24, 2009 6:51 AM by Qingsong Yao | 0 Comments

• My recommendation of SQL Server’s Globalization Development

  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 Tuesday, February 24, 2009 6:20 AM by Qingsong Yao | 0 Comments

• UTF-16 Encoding and SQL Server (4) - String Function Case Study

  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 Friday, February 13, 2009 6:32 AM by Qingsong Yao | 1 Comments

• 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 (3) - Length Semantic

  As you discuss in here and here before, in order to supporting UTF-16 encoding in SQL Server, we need to handle both "good" data and "bad" data, there are different approaches to achieve this. Today, I will talk about the length semantic again. In SQL Read More... Posted Thursday, February 05, 2009 6:20 AM by Qingsong Yao | 1 Comments

• UTF-16 Encoding and SQL Server (2)

  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 Monday, February 02, 2009 6:14 AM by Qingsong Yao | 1 Comments

• 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