February, 2009

Posts

| |

Collation, DateTime, SParse Column and XML

GB18030 Character Set Support in SQL Server

Posted over 3 years ago

by QingsongYao
- 0 Comments
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...
Collation, DateTime, SParse Column and XML

My recommendation of SQL Server’s Globalization Development

Posted over 3 years ago

by QingsongYao
- 0 Comments
Normal 0 false false false EN-US ZH-CN X-NONE ...
Collation, DateTime, SParse Column and XML

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

Posted over 3 years ago

by QingsongYao
- 1 Comments
Normal 0 false false false EN-US ZH-CN X-NONE ...
Collation, DateTime, SParse Column and XML

Introduce the Turkish I issue

Posted over 3 years ago

by QingsongYao
- 1 Comments
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...
Collation, DateTime, SParse Column and XML

UTF-16 Encoding and SQL Server (3) - Length Semantic

Posted over 3 years ago

by QingsongYao
- 1 Comments
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...
Collation, DateTime, SParse Column and XML

UTF-16 Encoding and SQL Server (2)

Posted over 3 years ago

by QingsongYao
- 1 Comments
Normal 0 false false false EN-US ZH-CN X-NONE ...
Collation, DateTime, SParse Column and XML

UTF-16 Encoding and SQL Server (1)

Posted over 3 years ago

by QingsongYao
- 4 Comments
Normal 0 false false false EN-US ZH-CN X-NONE ...