{"id":3453,"date":"2025-03-10T11:31:39","date_gmt":"2025-03-10T11:31:39","guid":{"rendered":"https:\/\/www.infobip.com\/developers\/?p=3453"},"modified":"2025-03-10T13:12:58","modified_gmt":"2025-03-10T13:12:58","slug":"those-pesky-collations","status":"publish","type":"post","link":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations","title":{"rendered":"Those pesky collations"},"content":{"rendered":"<div class=\"post__image\" style=\"--aspect-ratio: 1.85\/1\"><figure class=\"wp-block-post-featured-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1472\" height=\"832\" src=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg\" class=\"attachment-post-thumbnail size-post-thumbnail wp-post-image\" alt=\"\" style=\"object-fit:cover;\" srcset=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg 1472w, https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms-300x170.jpg 300w, https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms-1024x579.jpg 1024w, https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms-768x434.jpg 768w\" sizes=\"auto, (max-width: 1472px) 100vw, 1472px\" \/><\/figure><div class=\"post-image__fullscreen\"><img decoding=\"async\" src=\"https:\/\/www.infobip.com\/developers\/wp-content\/themes\/infobip_developers\/assets\/images\/icons\/fullscreen.svg\" alt=\"\"><\/div><\/div>\n\n\n<p class=\"wp-block-paragraph\">Collations are one of the most often overlooked properties in database deployment, usually taken for granted. Collation is a set of rules used for sorting and comparing data. It determines different properties, like case sensitivity, accent sensitivity, and other local rules. It also defines the consistency of the way data is stored and retrieved in an <a href=\"https:\/\/www.techtarget.com\/searchdatamanagement\/definition\/RDBMS-relational-database-management-system\" target=\"_blank\" rel=\"noreferrer noopener\">RDBMS<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are exactly three levels of collation definition in the SQL Server:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>server<\/li>\n\n\n\n<li>database<\/li>\n\n\n\n<li>column<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If you want a deep dive and learn more about collation, visit a dedicated <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/collations\/collation-and-unicode-support?view=sql-server-ver16\">MS learn<\/a> page.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why collation is important<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">I&#8217;ll try to demonstrate the importance of a collation setting through an example. As mentioned before, we can set up a collation on a column level, so I will use that option to explain.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s create a simple table. It has two string columns, one with a case-insensitive collation and the other with a case-sensitive counterpart.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>DROP TABLE IF EXISTS #t;\n \nCREATE TABLE #t\n(\n    Id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY CLUSTERED,\n    TokInsensitive VARCHAR(10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL \/*Case Insensitive Collation*\/,\n    TokSensitive VARCHAR(10) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL \/*Case Sensitive Collation*\/,\n);<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Obviously, I&#8217;ve watched a few TikToks while writing this post.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, let&#8217;s insert some data in the new table we&#8217;ve just created.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>INSERT INTO #t\n(\n    TokInsensitive,\n    TokSensitive\n)\nVALUES\n(&#39;TikTok&#39;, &#39;TikTok&#39;),\n(&#39;Tiktok&#39;, &#39;Tiktok&#39;),\n(&#39;tiktok&#39;, &#39;tiktok&#39;);<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">And yes, as you can see from the code snippet above, we did play around with letter cases in our entries.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, let&#8217;s see how the behavior of our outputs changes depending on the collation.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SELECT<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">We&#8217;ll now try to retrieve some rows from our table to see what happens. Let&#8217;s first try to get data regardless of letter cases, both minuscule and capital letters included. To do this, we&#8217;ll need to make sure our columns are &#8220;case insensitive&#8221;.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT &#39;InsensitiveSelect&#39; AS Descr,\n       *\nFROM #t\nWHERE TokInsensitive = &#39;TikTok&#39;;<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">As you can see from the results below, the table is retrieved with all the instances of letter cases.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"103\" src=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/image-2025-2-23_19-3-34.png\" alt=\"select-sensitive results\" class=\"wp-image-3455\" srcset=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/image-2025-2-23_19-3-34.png 400w, https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/image-2025-2-23_19-3-34-300x77.png 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If, however, you wish to retrieve specific data, which in our case would be case-sensitive, you&#8217;d need to specify that with the <code>SensitiveSelect<\/code> flag, like in the example below.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT &#39;SensitiveSelect&#39; AS Descr,\n       *\nFROM #t\nWHERE TokSensitive = &#39;TikTok&#39;;<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">In this case, your results will show the first instance that matched the query.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"393\" height=\"54\" src=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/image-2025-2-23_19-5-35.png\" alt=\"select-insensitive results\" class=\"wp-image-3456\" srcset=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/image-2025-2-23_19-5-35.png 393w, https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/image-2025-2-23_19-5-35-300x41.png 300w\" sizes=\"auto, (max-width: 393px) 100vw, 393px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">GROUP BY<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Things can get interesting when trying to group your data with the help of collation. If you try to organize data over our insensitive column, all results will be tallied up.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s examine the SQL code sample below to see what I&#8217;m talking about.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT &#39;InsensitiveGrouping&#39; AS Descr,\n       TokInsensitive,\n       COUNT(*) cnt\nFROM #t\nGROUP BY TokInsensitive;<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">As you can see, all letter case instances were considered and aggregated as one result.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"318\" height=\"46\" src=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/image-2025-2-23_19-10-7.png\" alt=\"group-insensitive results\" class=\"wp-image-3457\" srcset=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/image-2025-2-23_19-10-7.png 318w, https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/image-2025-2-23_19-10-7-300x43.png 300w\" sizes=\"auto, (max-width: 318px) 100vw, 318px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now, let&#8217;s see how the results differ if you try to group over the sensitive counterpart. In this instance, the code sample will look like this.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT &#39;SensitiveGrouping&#39; AS Descr,\n       TokSensitive,\n       COUNT(*) cnt\nFROM #t\nGROUP BY TokSensitive;<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">The data fetched will now differ greatly from the first example. All instances of letter cases will be interpreted and displayed as separate results.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"299\" height=\"102\" src=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/image-2025-2-23_19-12-24.png\" alt=\"group-sensitive results\" class=\"wp-image-3458\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Moral of the story<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As you can see, this humble property can lead to a variety of amusing results during tests. Still, it can also cause absolute mayhem when it gets forgotten or taken for granted during the deployment of production instances.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So take good care of your collations, folks!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"1024\" src=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/artworks-000605731930-1ql21b-t1080x1080-1024x1024.jpg\" alt=\"thats-it-folks-looney-tunes\" class=\"wp-image-3460\" srcset=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/artworks-000605731930-1ql21b-t1080x1080-1024x1024.jpg 1024w, https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/artworks-000605731930-1ql21b-t1080x1080-300x300.jpg 300w, https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/artworks-000605731930-1ql21b-t1080x1080-150x150.jpg 150w, https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/artworks-000605731930-1ql21b-t1080x1080-768x768.jpg 768w, https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/artworks-000605731930-1ql21b-t1080x1080.jpg 1080w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Collations are one of the most often overlooked properties [&hellip;]<\/p>\n","protected":false},"author":64,"featured_media":3462,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_import_markdown_pro_load_document_selector":21,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[28,254,252],"tags":[144,256,291],"coauthors":[302],"class_list":["post-3453","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-post","category-engineering-practices","category-tools","tag-developer-ecosystem","tag-programming","tag-sql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Those pesky collations - Infobip Developers Hub<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Those pesky collations - Infobip Developers Hub\" \/>\n<meta property=\"og:description\" content=\"Collations are one of the most often overlooked properties [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations\" \/>\n<meta property=\"og:site_name\" content=\"Infobip Developers Hub\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/infobip\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-10T11:31:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-10T13:12:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1472\" \/>\n\t<meta property=\"og:image:height\" content=\"832\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Leo Tausanovic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InfobipDev\" \/>\n<meta name=\"twitter:site\" content=\"@InfobipDev\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Leo Tausanovic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations\"},\"author\":{\"name\":\"Leo Tausanovic\",\"@id\":\"https:\/\/www.infobip.com\/developers\/#\/schema\/person\/bac81e18e7eee9dbac580d38e2f65cbc\"},\"headline\":\"Those pesky collations\",\"datePublished\":\"2025-03-10T11:31:39+00:00\",\"dateModified\":\"2025-03-10T13:12:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations\"},\"wordCount\":475,\"publisher\":{\"@id\":\"https:\/\/www.infobip.com\/developers\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg\",\"keywords\":[\"developer ecosystem\",\"programming\",\"SQL\"],\"articleSection\":[\"Blog Post\",\"Engineering Practices\",\"Tools\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations\",\"url\":\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations\",\"name\":\"Those pesky collations - Infobip Developers Hub\",\"isPartOf\":{\"@id\":\"https:\/\/www.infobip.com\/developers\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg\",\"datePublished\":\"2025-03-10T11:31:39+00:00\",\"dateModified\":\"2025-03-10T13:12:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#primaryimage\",\"url\":\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg\",\"contentUrl\":\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg\",\"width\":1472,\"height\":832},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.infobip.com\/developers\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Those pesky collations\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.infobip.com\/developers\/#website\",\"url\":\"https:\/\/www.infobip.com\/developers\/\",\"name\":\"Infobip Developers Hub\",\"description\":\"Build meaningful customer relationships across any channel\",\"publisher\":{\"@id\":\"https:\/\/www.infobip.com\/developers\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.infobip.com\/developers\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.infobip.com\/developers\/#organization\",\"name\":\"Infobip Developers Hub\",\"url\":\"https:\/\/www.infobip.com\/developers\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.infobip.com\/developers\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2023\/03\/Infobip_logo_favicon.png\",\"contentUrl\":\"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2023\/03\/Infobip_logo_favicon.png\",\"width\":696,\"height\":696,\"caption\":\"Infobip Developers Hub\"},\"image\":{\"@id\":\"https:\/\/www.infobip.com\/developers\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/infobip\/\",\"https:\/\/x.com\/InfobipDev\",\"https:\/\/www.youtube.com\/channel\/UCUPSTy53VecI5GIir3J3ZbQ\",\"https:\/\/github.com\/infobip-community\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.infobip.com\/developers\/#\/schema\/person\/bac81e18e7eee9dbac580d38e2f65cbc\",\"name\":\"Leo Tausanovic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.infobip.com\/developers\/#\/schema\/person\/image\/87bd3370bfa75c94f7fc86ca8e4c2d62\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5942ac03ef9a899ec89e4f9906a23bccd271f4c624806ec628d522a59c314661?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5942ac03ef9a899ec89e4f9906a23bccd271f4c624806ec628d522a59c314661?s=96&d=mm&r=g\",\"caption\":\"Leo Tausanovic\"},\"description\":\"Leo is a data aficionado, working as a MSSQL DBA on Big Data projects at Infobip for the last 10+ years. Loves the sea, reading, sea and sea.\",\"url\":\"https:\/\/www.infobip.com\/developers\/blog\/author\/leo-tausanovic\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Those pesky collations - Infobip Developers Hub","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations","og_locale":"en_US","og_type":"article","og_title":"Those pesky collations - Infobip Developers Hub","og_description":"Collations are one of the most often overlooked properties [&hellip;]","og_url":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations","og_site_name":"Infobip Developers Hub","article_publisher":"https:\/\/www.facebook.com\/infobip\/","article_published_time":"2025-03-10T11:31:39+00:00","article_modified_time":"2025-03-10T13:12:58+00:00","og_image":[{"width":1472,"height":832,"url":"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg","type":"image\/jpeg"}],"author":"Leo Tausanovic","twitter_card":"summary_large_image","twitter_creator":"@InfobipDev","twitter_site":"@InfobipDev","twitter_misc":{"Written by":"Leo Tausanovic","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#article","isPartOf":{"@id":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations"},"author":{"name":"Leo Tausanovic","@id":"https:\/\/www.infobip.com\/developers\/#\/schema\/person\/bac81e18e7eee9dbac580d38e2f65cbc"},"headline":"Those pesky collations","datePublished":"2025-03-10T11:31:39+00:00","dateModified":"2025-03-10T13:12:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations"},"wordCount":475,"publisher":{"@id":"https:\/\/www.infobip.com\/developers\/#organization"},"image":{"@id":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#primaryimage"},"thumbnailUrl":"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg","keywords":["developer ecosystem","programming","SQL"],"articleSection":["Blog Post","Engineering Practices","Tools"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations","url":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations","name":"Those pesky collations - Infobip Developers Hub","isPartOf":{"@id":"https:\/\/www.infobip.com\/developers\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#primaryimage"},"image":{"@id":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#primaryimage"},"thumbnailUrl":"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg","datePublished":"2025-03-10T11:31:39+00:00","dateModified":"2025-03-10T13:12:58+00:00","breadcrumb":{"@id":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#primaryimage","url":"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg","contentUrl":"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2025\/03\/rdbms.jpg","width":1472,"height":832},{"@type":"BreadcrumbList","@id":"https:\/\/www.infobip.com\/developers\/blog\/those-pesky-collations#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.infobip.com\/developers\/"},{"@type":"ListItem","position":2,"name":"Those pesky collations"}]},{"@type":"WebSite","@id":"https:\/\/www.infobip.com\/developers\/#website","url":"https:\/\/www.infobip.com\/developers\/","name":"Infobip Developers Hub","description":"Build meaningful customer relationships across any channel","publisher":{"@id":"https:\/\/www.infobip.com\/developers\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.infobip.com\/developers\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.infobip.com\/developers\/#organization","name":"Infobip Developers Hub","url":"https:\/\/www.infobip.com\/developers\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.infobip.com\/developers\/#\/schema\/logo\/image\/","url":"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2023\/03\/Infobip_logo_favicon.png","contentUrl":"https:\/\/www.infobip.com\/developers\/wp-content\/uploads\/2023\/03\/Infobip_logo_favicon.png","width":696,"height":696,"caption":"Infobip Developers Hub"},"image":{"@id":"https:\/\/www.infobip.com\/developers\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/infobip\/","https:\/\/x.com\/InfobipDev","https:\/\/www.youtube.com\/channel\/UCUPSTy53VecI5GIir3J3ZbQ","https:\/\/github.com\/infobip-community"]},{"@type":"Person","@id":"https:\/\/www.infobip.com\/developers\/#\/schema\/person\/bac81e18e7eee9dbac580d38e2f65cbc","name":"Leo Tausanovic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.infobip.com\/developers\/#\/schema\/person\/image\/87bd3370bfa75c94f7fc86ca8e4c2d62","url":"https:\/\/secure.gravatar.com\/avatar\/5942ac03ef9a899ec89e4f9906a23bccd271f4c624806ec628d522a59c314661?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5942ac03ef9a899ec89e4f9906a23bccd271f4c624806ec628d522a59c314661?s=96&d=mm&r=g","caption":"Leo Tausanovic"},"description":"Leo is a data aficionado, working as a MSSQL DBA on Big Data projects at Infobip for the last 10+ years. Loves the sea, reading, sea and sea.","url":"https:\/\/www.infobip.com\/developers\/blog\/author\/leo-tausanovic"}]}},"_links":{"self":[{"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/posts\/3453","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/users\/64"}],"replies":[{"embeddable":true,"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/comments?post=3453"}],"version-history":[{"count":9,"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/posts\/3453\/revisions"}],"predecessor-version":[{"id":3474,"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/posts\/3453\/revisions\/3474"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/media\/3462"}],"wp:attachment":[{"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/media?parent=3453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/categories?post=3453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/tags?post=3453"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.infobip.com\/developers\/wp-json\/wp\/v2\/coauthors?post=3453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}