I heart Java and love .NET

Sunday, September 15, 2013

Collations in In Memory tables and stored procedures

If you do string comparisons in your database and rely on case-insensitive search, beware that In-Memory requires BIN2 collation which is case sensitive.

Read more here on Bob Beauchemin's blog: Thinking about Hekaton? Then think about collations.

Additional information and workarounds described on MSDN Online
Posted by Ravi at 7:23 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2014 (5)
    • ►  May (1)
    • ►  February (4)
  • ▼  2013 (15)
    • ▼  September (13)
      • In Memory - what is the performance like ?
      • Collations in In Memory tables and stored procedures
      • Northwind on Hekaton
      • Presentation from NY Code Camp
      • Installing SQL Server 2014 on the VM
      • Demo: Transaction Log Optimization for In Memory T...
      • Demo: Create a Native Stored Procedure
      • Demo: Create a Memory Optimized Table
      • Demo: Create a Database and enable for In Memory
      • Install Windows Server 2012 R2 on the VM
      • Creating a Virtual Box VM
      • SQL Server 2014 In memory - Links to reference mat...
      • SQL Server 2014 In Memory
    • ►  January (2)

About Me

Ravi
View my complete profile
Simple theme. Theme images by luoman. Powered by Blogger.