{"id":171,"date":"2009-07-20T11:52:00","date_gmt":"2009-07-20T11:52:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=171"},"modified":"2009-07-20T11:52:00","modified_gmt":"2009-07-20T11:52:00","slug":"upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/","title":{"rendered":"Upgrading SageCRM to 6.1? Attention: – few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1"},"content":{"rendered":"

Upgrading SageCRM to 6.1? Attention: – few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1<\/p>\n

During a development session at our end, we came to know about these changes in SageCRM v6.1.<\/p>\n

Some of the fields from table Custom Captions were of type \u201cnVarChar\u201d up to version 6.0 of SageCRM. Now they are changed to type \u201cnText\u201d.<\/p>\n

Problem area:<\/strong> Suppose you have created a CustomView and used this nVarChar type field in that view and now you have upgraded the CRM to v6.1 then you might face an SQL error when this view will get used.<\/p>\n

Example:<\/strong> We have created a custom view for CustomCaptions and added the Capt_code field value for distinct records. When we designed this view; the field was of type of nVarchar and when we upgraded the system to v6.1 now it becomes nText. When user tried using the area where this custom view was used CRM thrown a SQL error.<\/p>\n

Solution:<\/strong> After investigation; what we have found that it is giving an error because of Type change and now we need to do Type cast of this field while using the same in view. We did the type casting for that field in View and Error resolved.<\/p>\n

HTH<\/p>\n

If you find this content useful, Please drop us an email at crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"

Upgrading SageCRM to 6.1? Attention: – few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1 During a development session at our end, we came to know about these changes in SageCRM v6.1. Some of the fields from table Custom Captions were of type \u201cnVarChar\u201d up to version 6.0 of SageCRM.\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[960,1138],"class_list":["post-171","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-developers","tag-field"],"yoast_head":"\nUpgrading SageCRM to 6.1? Attention: - few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1 - Sage CRM \u2013 Tips, Tricks and Components<\/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.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrading SageCRM to 6.1? Attention: - few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1 - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Upgrading SageCRM to 6.1? Attention: – few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1 During a development session at our end, we came to know about these changes in SageCRM v6.1. Some of the fields from table Custom Captions were of type \u201cnVarChar\u201d up to version 6.0 of SageCRM.\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-07-20T11:52:00+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/\",\"name\":\"Upgrading SageCRM to 6.1? Attention: - few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1 - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2009-07-20T11:52:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrading SageCRM to 6.1? Attention: – few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upgrading SageCRM to 6.1? Attention: - few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1 - Sage CRM \u2013 Tips, Tricks and Components","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.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/","og_locale":"en_US","og_type":"article","og_title":"Upgrading SageCRM to 6.1? Attention: - few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1 - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Upgrading SageCRM to 6.1? Attention: – few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1 During a development session at our end, we came to know about these changes in SageCRM v6.1. Some of the fields from table Custom Captions were of type \u201cnVarChar\u201d up to version 6.0 of SageCRM.\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2009-07-20T11:52:00+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/","name":"Upgrading SageCRM to 6.1? Attention: - few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1 - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2009-07-20T11:52:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/20\/upgrading-sagecrm-to-6-1-attention-few-nvarchar-fields-in-sagecrm-6-0-are-now-changed-to-ntext-in-sagecrm-6-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Upgrading SageCRM to 6.1? Attention: – few nVarchar fields in SageCRM 6.0 are now Changed to nText in SageCRM 6.1"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=171"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/171\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}