RE: MSSQL Server 2005 Unicode Support and EOF
RE: MSSQL Server 2005 Unicode Support and EOF
- Subject: RE: MSSQL Server 2005 Unicode Support and EOF
- From: "Webobjects" <email@hidden>
- Date: Wed, 2 Aug 2006 12:36:09 +0200
- Thread-topic: MSSQL Server 2005 Unicode Support and EOF
Perhaps
http://www.wodeveloper.com/omniLists/webobjects-talk/2004/January/msg00018.html
may give some hints how to patch the SQL in the desired way.
-----Original Message-----
From: webobjects-dev-bounces+webobjects=email@hidden [mailto:webobjects-dev-bounces+webobjects=email@hidden]On Behalf Of Dov Rosenberg
Sent: Monday, July 31, 2006 8:54 PM
To: WebObjects Dev
Subject: MSSQL Server 2005 Unicode Support and EOF
We have come across an issue supporting MSSQLServer 2005 and unicode languages in our WO/WOF based application. Our app has the ability to store multiple languages in a single database. In Oracle we use an AL32UTF8 character collation sequence and everything works fine. For SQL Server it appears that the only way I can store unicode characters in a table is that the columns need to be of type nchar, ntext, or nvarchar and a hint needs to be included in the INSERT or UDPATE clause that tells SQL Server that the string is a unicode string. For example:
For the following table
CREATE TABLE [CONTENTDATA] (
[RECORDID] nvarchar(64) NOT NULL,
[XML] ntext NULL,
CONSTRAINT [PK_CONTENTDATA] PRIMARY KEY([RECORDID])
)
insert into CONTENTDATA (RECORDID, XML) values (newid(), N'附属原爆後障害医療研究施設');
In case the japanese characters didn’t come thru the mail list:
insert into CONTENTDATA (RECORDID, XML) values (newid(), N'<some unicoded string>');
Notice the N in front of the string – that tells SQL Server to store it as unicode for the nchar, ntext, and nvarchar columns (not sure why it wouldn’t do that automatically for those datatypes). It appears that if I do an INSERT using the above notation the only way I can retrieve the data is appending the N into the qualifier as well. For example:
select * from CONTENTDATA where XML like N'附属原%'; <-- will retrieve the record inserted above
select * from CONTENTDATA where XML like '附属原%'; <-- will NOT retrieve the record inserted above
QUESTION: How/where can I modify the JDBC Plugin for EOF to adjust the way it generates the INSERT and UPDATE clauses of the outgoing SQL?
QUESTION: How can I modify the JDBC Plugin to do the SELECT qualifiers?
--
Dov Rosenberg
Inquira
Knowledge Management Experts
http://www.inquira.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden