I don't have much time to look into that now, but what we need to
investigate is what works at JDBC level. In the links you mentioned
before I don't see any references to JDBC behavior. Let's forget
Cayenne or EOF for a while. Just straight Java JDBC code.
* I.e. which one of the PreparedStatement syntax varieties work?
1. "INSERT ... N?" [bound as "XYZ"]
2. "INSERT ... ?" [bound as "N XYZ"]
3. "INSERT ... ?" [bound as "XYZ"]
4. Using Statement instead of PreparedStatement "INSERT ... 'N XYZ'"
* How all of the above behave on jTDS vs. MS drivers?
This is the basic info that we need to know to work on an adapter.
Also there maybe driver properties that control this behavior. E.g.
jTDS has "sendStringParametersAsUnicode".
Andrus
On Sep 20, 2006, at 10:33 AM, Dov Rosenberg wrote:
> 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 - 11:15:23 EDT