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'$BImB086Gz8e(B%';
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" <halse..vv.ntnu.no> 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 ("$BImB086Gz8e>c320eNE8&5f;..(B") 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
This archive was generated by hypermail 2.0.0 : Wed Sep 20 2006 - 10:34:01 EDT