We had the same behavior on our EOF based app until we logged out and then reconnected and started a new session. Then the WO application only shows ???? Same as Enterprise Manager.
The weird thing is if I tried doing a select like SELECT * FROM CONTENTDATA where xml like N'附属原爆後%'; It would return data only if I originally inserted the data using the N flag. Once I did that Enterprise Manager was able to display the data correctly. If EM can't display the data chances are other tools such as Crystal Reports probably won't be able to display it either. On 9/20/06 10:07 AM, "Tore Halset" <[EMAIL PROTECTED]> wrote: > On Sep 20, 2006, at 3:24, Dov Rosenberg wrote: > >> This article is a posting I made regarding our issues with EOF: >> http://lists.apple.com/archives/Webobjects-dev/2006/Jul/msg00743.html > > I did a quick test here in our live qa-system running cayenne-1.2, > tapestry-3.0.1, jtds-1.1, java-5 and MS SQL Server 2000. Pasted in > the text ("附属原爆後障害医療研究施設") in a form field > wired to a nvarchar(50), pressed the save-button wired to > commitChanges and did a new query. It just works! > > SQL Server Enterprise Manager are not able to display the text, but a > query in cayenne result in the correct String. > > - Tore. -- Dov Rosenberg Conviveon/Inquira Knowledge Management Experts http://www.conviveon.com http://www.inquira.com
