It sounds as though your AR server is not using Unicode. There's a limitation on the type of fields you can add to view forms - you have to be using a Unicode server to be able to see nvarchar (and other Unicode) fields and vice versa. One workaround to create a db view of the target form using the CAST operator to present the nvarchar field as a varchar.
Mark Walters The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or support representative for BMC Software, Inc. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Enslin Van Blerk - MWEB Sent: 15 February 2010 08:45 To: arslist@ARSLIST.ORG Subject: Re: [EvB]-------Create View Form It looks like Remedy does not understand the nvarchar(255) data type. If I change the data type to varchar(MAX) I can see the field in the view form. Is this the same for the xml column data type or is there a workaround for this? Thanks Enslin -----Original Message----- From: Enslin Van Blerk - MWEB Sent: 15 February 2010 10:23 AM To: 'arslist@ARSLIST.ORG' Subject: [EvB]-------Create View Form Hi everyone I need some help please. Remedy Server version 7.1 Patch 006 MSSQL 2005 I have a table with some nvarchar(255) and a xml column. How do I create a view in REMEDY that enables me to see all these fields? When I create the view I only see one column and that is a INT which is used for the Key field. I am not 100% sure what data to supply for you to assist me on this, please let me know. Thanks Enslin Connect with South Africa?s leading Internet Service Provider and discover the magic of the Internet and all its possibilities. Call 08600 32000 or click here(http://www.mweb.co.za/productsservices/) for more. MWEB :-) CONNECT AND YOU CAN. This electronic communication and the attached file(s) are subject to a disclaimer which can be accessed on the following link: Disclaimer - or copy the following URL into your browser - http://www.mweb.co.za/disclaimer. If you are unable to view the disclaimer, please contact ab...@mweb.com for a copy. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
