Browse by Tags

Tagged Content List
  • Blog Post: Avoid using varchar or char data type

    Today, I like to put one suggestion for choosing the data type of string column. My recommendation is always go with nvarchar type. You will not be regret if your database always using nvarchar type. For example, our SharePoint backend database always use nvarchar type, and they don't have any issue...
  • Blog Post: Do not alter database collation in your server

    Today, I like to provide one suggestion related to change database collation. In Alter Database T-SQL at http://msdn.microsoft.com/en-us/library/ms174269.aspx , we can see example of changing database 's collation as: Alter Database db2 collate latin1_general_ci_as It seems pretty trival to...
  • Blog Post: How to make Like Case Sensitive?

    Today, I got a question from customer: I have one column (Type: nVarchar) in a table which has data something like this: a1 aa aa2 AB I want to show all the rows which have all the lower case letters in the above mentioned column. The following query works: select * from test WHERE LTRIM(RTRIM(a)) LIKE...
  • Blog Post: 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 Kaplan's random stuff of dubious value is a great...
  • Blog Post: Beta version of collation selecting tool availiable

    Hello, Guys Please the attached zip file for the SQL Server collation selection tool. It is written in C#.
  • Blog Post: 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. 1. SQL Server doesn't support Unicode, do you mean...
  • Blog Post: 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 can start to write UTF-8 related stuff. So if you...
  • Blog Post: 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 value (either varchar or nvarchar value...
  • Blog Post: 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 the parameter equals to true, which is the default...
  • Blog Post: 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 finally I want group all these topics together...
  • Blog Post: 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 a database use the same collation, you will see less...
  • Blog Post: My recommendation of SQL Server’s Globalization Development

    Normal 0 false false false EN-US ZH-CN X-NONE ...
  • Blog Post: 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 Column Name exception if there is a difference...
  • Blog Post: UTF-16 Encoding and SQL Server (1)

    Normal 0 false false false EN-US ZH-CN X-NONE ...
  • Blog Post: Do we need a case insensitive binary collaton?

    In SQL Server, the binary collation (collation name ending with BIN2) use an algorithm which directly compare the code page of the characters. In other word, it is not linguistic sorting. However, it happens that it can sort alphabet and numbers correctly since we assign the code points of these characters...
  • Blog Post: 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 know collation, Congratulation! You are really...
  • Blog Post: Changing collation of a column is not so trival

    Several days ago, one customer asked me a question about collation. Here is the question: My applications requirement to search English characters along with accent characters like (å, Å), If we search Name “James “ by my application it should return both names “James” and “Jåmes”. We are using...
  • Blog Post: 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 sorting of Windows Server 2008 (they...
  • Blog Post: 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 can't use Binary collating sequence, then we...
Page 1 of 1 (19 items)