Have really not seen a solid answer on this. We are having similar issues. So basically mid-tier submit Japanese without issue and from the client if they are using Japanese no issues. Our issue is we import data through a SQL job from a Oracle database using the Linked Server on SQL 2005. On the Oracle server the fields are nchar or nvarchar, but when they go through the linked server the translate to vchar and varchar.
Not finding any reason this is happening and no SQL help I can see. Data comes in upside ??? marks. We are running ARS 7.0.1 patch 2 on SQL 2005 on Windows 2003. Thanks ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Shellman, David Sent: Wednesday, October 01, 2008 3:14 PM To: [email protected] Subject: Re: Regarding Unicode database During the install there are 2 places for language. The first sets the language that the rest of the install will use. The second is used for the text on the client menus. Only know about the Locale and OS interaction because of testing in China between Traditional and Simplified Chinese for by Helpdesks in China and Taiwan. We have also found out that care must be taken if fields display ???? and someone updates even a single field in the record using the desktop client. What happens is the record is no longer readable in the original language or English. The original characters, that are not displaying correctly, are replaced in all the fields in the form and not just the single field. It's a touchy situation that we have not figured out how to trap with the desktop client. It was suggested that we capture the LOCALE keyword of the original submitter. Testing found that can often not be correct if it is not set within the desktop client. However the record can be updated by anyone using the MidTier and the record will retain the mixture of the original language and what ever language was used for the update. Dave ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe DeSouza Sent: Wednesday, October 01, 2008 2:52 PM To: [email protected] Subject: Re: Regarding Unicode database ** I remember Axton's post regarding this.. I wasn't aware that the desktop client wasn't fully UTF-8 compliant until that.. Well you learn a new thing everyday :-) I am an English user so had assumed that when you selected the language options on your client install, it would mean that it would install a build that supported the reading of those foreign characters. Joe ----- Original Message ---- From: "Shellman, David" <[email protected]> To: [email protected] Sent: Wednesday, October 1, 2008 2:32:54 PM Subject: Re: Regarding Unicode database ** Joe, Not quite right. The data may be stored in the database correctly. The issue is the display of the data through the client. As Axton noted the MidTier is the only true Unicode client. The desktop client is not Unicode compliant and is dependent on the Locale setting in the client and the Windows OS on the system that the client is installed. Dave ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe DeSouza Sent: Monday, September 22, 2008 11:55 AM To: [email protected] Subject: Re: Regarding Unicode database ** The ? represent a character that is not interpreted by the AR Server. It is a double byte character, and the AR Server does not know how to display it as it has not been setup with the right character set required to display the contents.. Joe ----- Original Message ---- From: anil RAI <[email protected]> To: [email protected] Sent: Monday, September 22, 2008 4:19:23 AM Subject: Re: Regarding Unicode database ** Hi Joe, I am getting ????????. Thanks Anil --- On Mon, 22/9/08, Joe DeSouza <[email protected]> wrote: From: Joe DeSouza <[email protected]> Subject: Re: Regarding Unicode database To: [email protected] Date: Monday, 22 September, 2008, 11:02 AM ** What do you mean by data does not display in a proper format? What do you see - as opposed to? Joe ----- Original Message ---- From: anil RAI <[email protected]> To: [email protected] Sent: Monday, September 22, 2008 12:50:28 AM Subject: Re: Regarding Unicode database ** Hi Axton, I have done all these settings. I have imported the non unicode database to uncode supported database. When i am checking from SQL prompt , the data is displaying in proper format. After upgrade of ARS when i am entering data from the midtier and when search the records , the records are displaying in proper format. When i am trying to search the records which i have imported on unicode supported then the records are not displaying in the proper format. My only problem is that imported data are not displaing in a proper way. Please give your inputs on this. Thanks & Regards Anil __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
