TMS Users,

 

I can reply to my own post – Danielle Uchitelle at Gallery Systems helped me resolve this problem. With the TMS 2012 change of some varchar fields to nvarchar, Crystal Reports did not interpret these correctly, and so was truncating lots of fields to 255 characters. To get around this, I created a SQL view that cast these fields as text, when they should have been ntext. Big difference.

 

Having updated whole report and parts of reports using this view, non-Western characters began to to not display properly. Hope this helps any of you with some of the same symptoms.

 

Thanks, Danielle!

 

 

Dear TMS Users,

 

Does anyone have a solution or a workable explanation as to why reports that use Arial Unicode MS to display non-Western characters no longer display this text properly, either within Crystal or TMS?  I get ???? where I want雲谷.

 

We are on Crystal XI – is anyone using more recent versions of Crystal and not having issues?

 

Thanks for any information you can provide.

 

Jeffrey Smith

Assistant Registrar for Collections Information

Freer Gallery of Art and Arthur M. Sackler Gallery

[log in to unmask]

202-633-0348

 

 

Experience where Asia meets America at the

Smithsonian’s museums of Asian art

 

Connect with F|S on social media

@freersackler #freersackler

 

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.