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'附属原爆後%';
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
