{"id":222,"date":"2009-09-30T14:05:48","date_gmt":"2009-09-30T13:05:48","guid":{"rendered":"https:\/\/www.alldb.fr\/blogs\/?p=222"},"modified":"2023-04-20T07:05:02","modified_gmt":"2023-04-20T06:05:02","slug":"modifier-la-collation-dune-base-sql-2005","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/","title":{"rendered":"Modifier la Collation d’une base SQL 2005"},"content":{"rendered":"\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>

<\/p>\n

La collation (ou classement en fran\u00e7ais) d\u2019une base de donn\u00e9es indique le jeu de caract\u00e8res et l\u2019ordre de tri des donn\u00e9es stock\u00e9es dans la base de donn\u00e9es. De nombreux articles expliquent le r\u00f4le et traitent des probl\u00e8mes de collation. L\u2019objectif de celui-ci est de pr\u00e9senter une m\u00e9thode pour changer la collation d\u2019une base de donn\u00e9es.<\/p>\n

La collation peut \u00eatre fix\u00e9e:<\/p>\n

    \n
  1. Au niveau de l\u2019instance: \u00e0 l\u2019installation de SQL Server 2005.<\/li>\n
  2. Au niveau de la base:\n
     CREATE DATABASE ... COLLATE ou ALTER DATABASE ... COLLATE.<\/pre>\n<\/li>\n
  3. Au niveau de la colonne:\n
    CREATE TABLE maTable ... COL1 NVARCHAR(100) COLLATE French_CI_AS<\/pre>\n<\/li>\n
  4. Au niveau de l\u2019expression SQL:\n
    SELECT A, B from T1, T2 where T1.A = T2.B collate French_CI_AS<\/pre>\n<\/li>\n<\/ol>\n
    On peut parfois se retrouver dans la situation suivante :  la base de donn\u00e9es a \u00e9t\u00e9 cr\u00e9\u00e9e ou restaur\u00e9e dans une collation qui pose probl\u00e8me \u00e0 l\u2019application et il faut la modifier.<\/p>\n
     <\/p>\n
    Attention<\/strong>, gare alors aux probl\u00e8mes lorsque l\u2019on utilise des bases de collations diff\u00e9rentes sur une m\u00eame instance : La collation de tempdb est h\u00e9rit\u00e9e de model, qui elle-m\u00eame h\u00e9rite de celle de l\u2019instance. Lors de jointures avec des tables temporaires sur des colonnes contenant du texte, des erreurs de comparaison peuvent survenir: <\/span><\/p>\n
    Msg 468, Level 16, State 9, Line 5 Cannot resolve the collation conflict between\r\n\"French_CI_AS\" and \"Latin1_General_CI_AS_KS_WS\" in the equal to operation<\/span><\/pre>\n
     <\/p>\n
    Pour changer la collation d\u2019une base de donn\u00e9es, il existe plusieurs techniques :<\/p>\n
    Technique 1 : <\/span><\/strong><\/p>\n
      \n
    1. Modifier la collation de la base\u00a0: ALTER DATABASE … COLLATE
      \n<\/span>Toutes les nouvelles colonnes de type caract\u00e8re cr\u00e9\u00e9es dans la base h\u00e9riteront de la nouvelle collation mais pas les colonnes caract\u00e8re d\u00e9j\u00e0 cr\u00e9\u00e9es .<\/li>\n
    2. Modifier  <\/span>la collation de chaque colonne \u00e0 condition quelle ne soit pas r\u00e9f\u00e9renc\u00e9e dans un index, une contrainte Foreign key ou CHECK, une statistique de distribution ou une colonne calcul\u00e9e
      \n\u2026 pas \u00e9vident<\/li>\n<\/ol>\n
      Technique 2<\/strong> <\/span>: celle que je vous propose<\/p>\n
        \n
      1. G\u00e9n\u00e9rer le script de cr\u00e9ation de la base et de tous ses objets<\/li>\n
      2. Modifier ce script, pour cr\u00e9er une nouvelle base vide avec la bonne collation<\/li>\n
      3. Importer dans la nouvelle base les donn\u00e9es de l\u2019ancienne base \u00e0 l\u2019aide de l\u2019assistant de Management Studio<\/li>\n
      4. V\u00e9rifier si l\u2019application fonctionne correctement sur la nouvelle base<\/li>\n
      5. Intervertir l\u2019ancienne base et la nouvelle
        \nOn peut renommer une base ( commande ALTER DATABASE \u2026 MODIFY NAME<\/span>). Attention de bien r\u00e9cup\u00e9rer les comptes utilisateurs de l\u2019ancienne base et le mapping sur les logins.<\/li>\n<\/ol>\n
        Exemple <\/strong>: Changer la collation de la base AdventureWorks Latin1_General_CS_AS en <\/span>En French_CI_AS<\/p>\n
        Avant de commencer:<\/p>\n
        — V\u00e9rifier la collation du serveur<\/p>\n
        sp_helpsort<\/pre>\n
        Server default collation\r\n---------------------------------------------------------------------------\r\nFrench, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive<\/span><\/span><\/pre>\n
        — V\u00e9rifier la collation de la base<\/p>\n
        select DATABASEPROPERTYEX('AdventureWorks', 'Collation')<\/span>\r\n-----------------------------------------------------------------------\r\nLatin1_General_CS_AS<\/span><\/pre>\n
        — V\u00e9rifier la collation des colonnes<\/p>\n
        SELECT B.table_name, column_name, collation_name, data_type FROM INFORMATION_SCHEMA.COLUMNS A,\r\nINFORMATION_SCHEMA.TABLES B\r\nWHERE A.table_name = B.table_name and collation_name is not null\r\nORDER BY B.table_name<\/pre>\n
        table_name    column_name   collation_name             data_type\r\n-----------------------------------------------------------------------------------\r\nAddress       AddressLine1  Latin1_General_CS_AS        nvarchar\r\nAddress       AddressLine2  Latin1_General_CS_AS        nvarchar\r\n...<\/span><\/pre>\n
        \n
         <\/span><\/span><\/p>\n<\/blockquote>\n
        Etape 1<\/strong><\/span> : G\u00e9n\u00e9rer le script de cr\u00e9ation de la base et de tous ses objets<\/p>\n
        A Partir de Management Studio, cliquer sur “Generate Scripts”<\/p>\n
        \"\"<\/a><\/p>\n
        —
        \nChoisir la base AdventureWorks,
        \nCocher l’option “Script All Objects”
        \nNext
        \n—
        \n Choose script Options
        \nModifier les options suivantes\u00a0:
        \nInclude Descriptive Headers: True
        \nScript Database Create: True
        \nScript Object-Level Permissions : True
        \nScript USE DATABASE : False
        \nScript Full-Text Indexes : True<\/span>
        \n—
        \nNext
        \nScript to New Query Window
        \n—
        \nNext
        \n—
        \nFinish
        \n—
        \nClose\n<\/p>\n
        Etape 2<\/strong><\/span> :  Modifier ce script, pour cr\u00e9er une nouvelle base vide avec la bonne collatio<\/span><\/p>\n
        Avec l’outil Find\/Replace Remplacer le mot AdventureWorks par AdventureWorks_2
        \n(nom de la nouvelle base)<\/p>\n
         \n<\/p>\n
        Modifier la Collation de la base de donn\u00e9es avec la valeur voulue en ajoutant la clause collate<\/p>\n
        CREATE DATABASE\r\n\u2026\r\n( NAME =\r\nN'AdventureWorks_2_Log', FILENAME = N'C:\\Program Files\\Microsoft SQL\r\nServer\\MSSQL.1\\MSSQL\\DATA\\AdventureWorks_2_Log.ldf' , SIZE = 916352KB , MAXSIZE\r\n= UNLIMITED, FILEGROWTH = 10%)\r\nCOLLATE FRENCH_CI_AS<\/strong>\r\nEND<\/span><\/pre>\n
        Modifier les chemins des fichiers de donn\u00e9es en cas de besoin (pour ne pas utiliser les m\u00eames que la base d\u2019origine).<\/p>\n
        <\/p>\n
        => Ex\u00e9cuter le script<\/p>\n
        V\u00e9rifier qu\u2019il n\u2019y a pas d\u2019erreur probl\u00e9matique lors de la cr\u00e9ation de la base et de ses objetts.
        \nV\u00e9rifier la collation de la nouvelle base et de ses colonnes.\n<\/p>\n
        <\/p>\n
        \n
        Etape 3<\/strong> : Importer dans la nouvelle base les donn\u00e9es les donn\u00e9es de l\u2019ancienne<\/p>\n
        A l\u2019aide SSMS depuis la base AdventureWorks_2, lancer l\u2019assistant d\u2019import de donn\u00e9es : <\/span><\/p>\n
        <\/p>\n
        \"Import<\/a><\/p>\n
        —
        \nChoose a Datasource: AdventureWorks
        \nNext
        \n—
        \nChoose a destination : AdventureWorks_2
        \nNext
        \n—
        \nCopy data from one or more tables or views
        \nNext
        \n—
        \nNe s\u00e9lectionner que les tables , pas les vues
        \nNext
        \n—
        \nExecute immediately
        \nNext
        \nFinish
        \n—-<\/p>\n
        \n<\/p>\n
        Les lignes de chaque table ont \u00e9t\u00e9 ajout\u00e9es aux tables vides avec la nouvelle collation pour les donn\u00e9es type Caract\u00e8re<\/p>\n
        L.Hochberg<\/p>\n\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>","protected":false},"excerpt":{"rendered":"
        L\u2019objectif de cet article est de pr\u00e9senter une m\u00e9thode pour changer la collation d\u2019une base de donn\u00e9es. Continuer la lecture →<\/span><\/a><\/p>\n","protected":false},"author":14,"featured_media":7974,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,450],"tags":[41],"class_list":["post-222","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","category-vintage","tag-sql-server-collation"],"yoast_head":"\nModifier la Collation d'une base SQL 2005 - Capdata TECH BLOG<\/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:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Modifier la Collation d'une base SQL 2005 - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"L\u2019objectif de cet article est de pr\u00e9senter une m\u00e9thode pour changer la collation d\u2019une base de donn\u00e9es. Continuer la lecture →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2009-09-30T13:05:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-20T06:05:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2009\/09\/language-605x357_full.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1366\" \/>\n\t<meta property=\"og:image:height\" content=\"806\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Benjamin VESAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin VESAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/\"},\"author\":{\"name\":\"Benjamin VESAN\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e\"},\"headline\":\"Modifier la Collation d’une base SQL 2005\",\"datePublished\":\"2009-09-30T13:05:48+00:00\",\"dateModified\":\"2023-04-20T06:05:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/\"},\"wordCount\":723,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"sql server collation\"],\"articleSection\":[\"SQL Server\",\"Vintage\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/\",\"name\":\"Modifier la Collation d'une base SQL 2005 - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2009-09-30T13:05:48+00:00\",\"dateModified\":\"2023-04-20T06:05:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Modifier la Collation d’une base SQL 2005\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e\",\"name\":\"Benjamin VESAN\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/bvesan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Modifier la Collation d'une base SQL 2005 - Capdata TECH BLOG","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:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/","og_locale":"fr_FR","og_type":"article","og_title":"Modifier la Collation d'une base SQL 2005 - Capdata TECH BLOG","og_description":"L\u2019objectif de cet article est de pr\u00e9senter une m\u00e9thode pour changer la collation d\u2019une base de donn\u00e9es. Continuer la lecture →","og_url":"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2009-09-30T13:05:48+00:00","article_modified_time":"2023-04-20T06:05:02+00:00","og_image":[{"width":1366,"height":806,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2009\/09\/language-605x357_full.jpg","type":"image\/jpeg"}],"author":"Benjamin VESAN","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Benjamin VESAN","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/"},"author":{"name":"Benjamin VESAN","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e"},"headline":"Modifier la Collation d’une base SQL 2005","datePublished":"2009-09-30T13:05:48+00:00","dateModified":"2023-04-20T06:05:02+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/"},"wordCount":723,"commentCount":1,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["sql server collation"],"articleSection":["SQL Server","Vintage"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/","url":"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/","name":"Modifier la Collation d'une base SQL 2005 - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2009-09-30T13:05:48+00:00","dateModified":"2023-04-20T06:05:02+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/modifier-la-collation-dune-base-sql-2005\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"Modifier la Collation d’une base SQL 2005"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e","name":"Benjamin VESAN","url":"https:\/\/blog.capdata.fr\/index.php\/author\/bvesan\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=222"}],"version-history":[{"count":22,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/222\/revisions"}],"predecessor-version":[{"id":7975,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/222\/revisions\/7975"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7974"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}