Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 6
Registered: ‎07-21-2009

TextBlob:Text => nText data type for database field.

I've got a custom process that feeds tickets filed on our web site into the SLX ticket system.  It has worked fine for ~4 years over various versions of SLX.  We recently launched in Japan and have moved the web database from using text() and varchar() to ntext and nvarchar().  I moved several fields in SLX from varchar() to nvarchar() without problem by making the change directly in SQL.  However when I recently changed TicketProblem.Notes from the SalesLogix Customer type TextBlob:Text to ntext() I get cast errors when creating a ticket.

 

I'm running 7.2.2.  I tried to profile the database while I got the error but couldn't match up what I was seeing in profiler and the simple bit of code that was being reported as the error.  I saw that 7.5.x lists full unicode support and was wondering if I can work around this in some way on 7.2.2 or should I just move to 7.5.x?

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: TextBlob:Text => nText data type for database field.

7.5.2 is your best bet. However it does not really do "full Unicode", it is "UniCode ready".

 

Also, There's no changes in the SalesLogix Windows Client to support Unicode. None of the controls in the Windows Client support UniCode and AFAIK there are no plans to do so.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html