Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Subject: AW: SQL Server 2005 - varchar(max)
Date: Mon, 17 Nov 2008 10:38:21 +0100
Content-Type: multipart/signed;
	protocol="application/x-pkcs7-signature";
	micalg=SHA1;
	boundary="----=_NextPart_000_0045_01C948A0.9C00DFC0"
Message-ID: <0765101BA5724F4DAC1607B4CF4BC171DA4A13@scuderia09.vps.local>
In-Reply-To: 
 <55B8568AFA5F144F886F18186BAD5B2C25C66B99@durham-e2k7mb1.dukece.com>
Thread-Topic: SQL Server 2005 - varchar(max)
Thread-Index: AclGaeq064zBOTtwT3GirupcOL/EQwAAXIVgAAOgGYAAh120YA==
References: <1226674913.8357.ezmlm@db.apache.org>
 <ECF008F200CE49879DAF45ACE4C66B9A@coe.local>
 <55B8568AFA5F144F886F18186BAD5B2C25C66B99@durham-e2k7mb1.dukece.com>
From: "Tobias Hilka" <thilka@vps.de>
To: "Apache Torque Users List" <torque-user@db.apache.org>

------=_NextPart_000_0045_01C948A0.9C00DFC0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,

we actually use NVARCHAR columns of SQL Server 2005.
We wrote our own platform generator which maps VARCHAR columns in the
schema-xml to NVARCHAR columns in the database. Works fine.

There is only one issue with this: We had to adjust the SQL statements
generated by SQLExpression to add an 'N' in front of every unicode =
value.

I think I opened an issue for this in JIRA some time ago.

@Torque developers: Is there any reason why the data type mapping has to =
be
done in a java file, in older version there was some kind of text file =
in
which you can specify the mapping. We always have to add our changes to =
your
code if a new version comes out.

Tobias
=20
-----Urspr=FCngliche Nachricht-----
Von: Greg Monroe [mailto:monroe@dukece.com]=20
Gesendet: Freitag, 14. November 2008 18:14
An: 'Apache Torque Users List'
Betreff: RE: SQL Server 2005 - varchar(max)

First, just a general Torque design principal review... Torque
tries to let you create code that is independent of the type
of SQL server you are using (while remaining flexible enough
to let you access specific server features.  When it comes to
things like basic column type support, we follow the SQL
standards as to what Torque supports.  So, if the standard
defines an NVARCHAR column type, then we will try to support
it across all servers we support.

That said, there are actually two parts to this request, using
these type of columns in the runtime and generating the SQL
statements to create the tables.

In the runtime area, I'm pretty sure we already support these
columns.  If your schema XML says VARCHAR, then the Torque code is
using String at the storage type with is Unicode compliant. Torque
and Village ultimate set and store these fields via JDBC calls, like
getString(column), and the like.  The JDBC driver should handle the
conversion of the information returned by the SQL server to the
correct Java value.  So, an NVARCHAR column with Unicode will be
mapped directly to a Unicode String with no problems.

As to generating SQL with NVarchar column, as I said above, if this
is  part of the standard, we'll add a column type to the schema.

However, if you have a need to do this, it's not hard to create
your own generator Platform implementation that uses NVARCHAR
when you specify VARCHAR in the XML.

Hope makes sense.  If not feel free to ask for clarification.


> -----Original Message-----
> From: jbowman [mailto:jbowman@coemergence.com]
> Sent: Friday, November 14, 2008 10:28 AM
> To: torque-user@db.apache.org
> Subject: SQL Server 2005 - varchar(max)
>
> Hi All,
>
> I'm new to the list so please bear with me if this question has been
> previously discussed.
>
> Is there any version of Torque that supports any of the "new" SQL =
Server
> 2005 column specification changes, specifically:
>
> NVARCHAR(max)?
>
>
> The MSDN documentation defines it as:
>
> "Variable-length Unicode character data. n can be a value from 1 =
through
> 4,000. max indicates that the maximum storage size is 2^31-1 bytes. =
The
> storage size, in bytes, is two times the number of characters entered =
+ 2
> bytes. The data entered can be 0 characters in length."
>
> If not, are there any plans in the works to support such SQL Server =
2005
> changes?
>
> John
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>

DukeCE Privacy Statement:
Please be advised that this e-mail and any files transmitted with
it are confidential communication or may otherwise be privileged or
confidential and are intended solely for the individual or entity
to whom they are addressed. If you are not the intended recipient
you may not rely on the contents of this email or any attachments,
and we ask that you please not read, copy or retransmit this
communication, but reply to the sender and destroy the email, its
contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is
strictly prohibited.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


------=_NextPart_000_0045_01C948A0.9C00DFC0
Content-Type: application/x-pkcs7-signature;
	name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="smime.p7s"

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIPSzCCBJUw
ggN9oAMCAQICAwMOlTANBgkqhkiG9w0BAQUFADBLMQswCQYDVQQGEwJERTEVMBMGA1UECgwMRC1U
cnVzdCBHbWJIMSUwIwYDVQQDDBxELVRSVVNUIFJvb3QgQ2xhc3MgMiBDQSAyMDA3MB4XDTA3MDUx
NjA1MjA0N1oXDTIyMDUxNjA1MjA0N1owSzELMAkGA1UEBhMCREUxFTATBgNVBAoMDEQtVHJ1c3Qg
R21iSDElMCMGA1UEAwwcRC1UUlVTVCBSb290IENsYXNzIDIgQ0EgMjAwNzCCASIwDQYJKoZIhvcN
AQEBBQADggEPADCCAQoCggEBALPN5IQVSfjk1s6Es5qt9jB1kA2E6+7as3p1KuI7pOowLOs9d42B
hGhKpqRo3JBzYTRlBx0jpQzmv9PdM13aMu2mDVOmdGpcGVmmTLUveQFenn9K+rrJJ37U/80AWSDr
BsyzRM/WhentOwxsweqMXOC5qQLwEwAnk5xQ/s0TT20baqrdD/9GJRnc4V5QrBp/Dsva7iD8w/Sc
Sng1bu4xx0UWcoXSgiDbUkV8PL9ZV/mHdFaYWx1Qjswvs7M/i+7sN0kBiO/YIQyT0/ZuiU+6F8tE
gbd7pyO7dArT2Oo3RSf/3PCeQ+O6e4obmn3phqD+L9HW9odXqvIplIdzFfpqTq0CAwEAAaOCAYAw
ggF8MA8GA1UdEwEB/wQFMAMBAf8wHQYDVR0OBBYEFJEwq/bzxkS3690ovA8Un1JdYn8CMDkGCCsG
AQUFBwEBBC0wKzApBggrBgEFBQcwAYYdaHR0cDovL3VzZXJzLm9jc3AuZC10cnVzdC5uZXQwMwYD
VR0RBCwwKoEQaW5mb0BkLXRydXN0Lm5ldIYWaHR0cDovL3d3dy5kLXRydXN0Lm5ldDAOBgNVHQ8B
Af8EBAMCAQYwgckGA1UdHwSBwTCBvjCBu6CBuKCBtYZ2bGRhcDovL2RpcmVjdG9yeS5kLXRydXN0
Lm5ldC9DTj1ELVRSVVNUJTIwUm9vdCUyMENsYXNzJTIwMiUyMENBJTIwMjAwNyxPPUQtVHJ1c3Ql
MjBHbWJILEM9REU/Y2VydGlmaWNhdGVyZXZvY2F0aW9ubGlzdIY7aHR0cDovL3d3dy5kLXRydXN0
Lm5ldC9jcmwvZC10cnVzdF9yb290X2NsYXNzXzJfY2FfMjAwNy5jcmwwDQYJKoZIhvcNAQEFBQAD
ggEBAFuL8kPjBS5kH9WSqVFrZPwORswHmeK3/JMpINz8L2DkrH0lMu0Q4Q9v2/K8Tu5BybPUB0h6
Cq+ktv9RMO3L0pzrf1DuS+JipzTCIPbz9vU2wMuREOvtLo30BxohDDV39HwtjUml1wtEaNXS4uUM
eDgTyrFMUqoq5dWvXAU5nS2tviNW1S9V896dq4I2oE23WZFH7t6Dpeo7XicFgAttLFD0ATfVo3cX
7P7dhPTF+FCS0EvGLqOLQOTDN6N3vc4sVeKs311kALq+p2oxBvyZa1AVJZ2pdpqnTSqaAmPrcOf+
ESbQGMWmHwpDk/IY2fU5ebgHXYwf5j/zxcshZjF7e88wggUcMIIEBKADAgECAgMDDpswDQYJKoZI
hvcNAQEFBQAwSzELMAkGA1UEBhMCREUxFTATBgNVBAoMDEQtVHJ1c3QgR21iSDElMCMGA1UEAwwc
RC1UUlVTVCBSb290IENsYXNzIDIgQ0EgMjAwNzAeFw0wNzA1MTYwNTIwNDdaFw0xMjA1MTYwNTIw
NDdaME8xCzAJBgNVBAYTAkRFMRUwEwYDVQQKDAxELVRydXN0IEdtYkgxKTAnBgNVBAMMIEQtVFJV
U1QgQWR2YW5jZWQgQ2xhc3MgMiBDQSAyMDA3MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKC
AQEAqaO5i/9YVAfdViGRwhI/6OzkKRmtZYolb2d1l7ADZgu/OiSF9F66YtvSKfx6LwdkHQ6Ags/I
AnGyE9TG9eUihDyMg5/kiNK90WdBEcI7tkdI0o+MQmll9l7ZJQXGZr9PtZi26+ZW8+vL2zD16pa6
o7/Ysm6meCnOM1a/1Wf2+syVKOVzs2MI08B46OAShjItvwkwJ3nB2rL6nQ8HF2A6q28NVsZklNlS
jTTnVU3r93Mi7YVKPDV6FMVzD5zBhiiLW/DyqD8cDvBT6OW031TnfpUqUNKZM1AoPApqVHA0GE9w
EGyKRjTdzLQavEPBR2qV+sVTxX5sMCPIS5oCi+8iiQIDAQABo4ICAzCCAf8wHwYDVR0jBBgwFoAU
kTCr9vPGRLfr3Si8DxSfUl1ifwIwOQYIKwYBBQUHAQEELTArMCkGCCsGAQUFBzABhh1odHRwOi8v
dXNlcnMub2NzcC5kLXRydXN0Lm5ldDBdBgNVHSAEVjBUMFIGCysGAQQBpTQCgUgBMEMwQQYIKwYB
BQUHAgEWNWh0dHA6Ly93d3cuZC10cnVzdC5uZXQvcmVwb3NpdG9yeS9DUFNfQ2xhc3NfM18yXzEu
cGRmMDMGA1UdEQQsMCqBEGluZm9AZC10cnVzdC5uZXSGFmh0dHA6Ly93d3cuZC10cnVzdC5uZXQw
gckGA1UdHwSBwTCBvjCBu6CBuKCBtYZ2bGRhcDovL2RpcmVjdG9yeS5kLXRydXN0Lm5ldC9DTj1E
LVRSVVNUJTIwUm9vdCUyMENsYXNzJTIwMiUyMENBJTIwMjAwNyxPPUQtVHJ1c3QlMjBHbWJILEM9
REU/Y2VydGlmaWNhdGVyZXZvY2F0aW9ubGlzdIY7aHR0cDovL3d3dy5kLXRydXN0Lm5ldC9jcmwv
ZC10cnVzdF9yb290X2NsYXNzXzJfY2FfMjAwNy5jcmwwHQYDVR0OBBYEFP6XXHdVtcf2fFA0EgKD
+cqbpcy2MA4GA1UdDwEB/wQEAwIBBjASBgNVHRMBAf8ECDAGAQH/AgEAMA0GCSqGSIb3DQEBBQUA
A4IBAQALdi1JoliAfmvyCEJpLPnbUNUEayALfqwXraesmrNALJs5l3Ii3HKIrhYt8TOFA/JoFIgD
wD6Dh1rucoYlCVfr7XnLJByE9WxXkHkPTaxCQK+W5ATFRQEeGdXMYf1RzUPRQU4Dpl+V9YbsIn0u
zGN2OrDiKMI+GpxvMFtibvhfX0xUnk2M7yEV4TNegb819fKWQQL+fR4pudUo3M5L6QAkO1t2dG8R
AytoN4d+81zATT0zCqHXdLKqancpa4niYAzVVJJfI70sI3UFd8viFRdbT7QEES82hoqxEkv8tumv
HTk/OmBnY9tPspdRL7MbxjEvN34LYBHLDhRUEzvwP2gPMIIFjjCCBHagAwIBAgIDB1qIMA0GCSqG
SIb3DQEBBQUAME8xCzAJBgNVBAYTAkRFMRUwEwYDVQQKDAxELVRydXN0IEdtYkgxKTAnBgNVBAMM
IEQtVFJVU1QgQWR2YW5jZWQgQ2xhc3MgMiBDQSAyMDA3MB4XDTA4MDUxNjA2NTk0NFoXDTEwMDUy
NjA4NDUyNVowgYkxCzAJBgNVBAYTAkRFMRwwGgYDVQQKDBN2cHMgSUQgU3lzdGVtZSBHbWJIMRUw
EwYDVQQDDAxUb2JpYXMgSGlsa2ExFjAUBgNVBCoMDVRvYmlhcyBNYXJrdXMxDjAMBgNVBAQMBUhp
bGthMR0wGwYDVQQFExREVFJXRTIwOTM5MTE5Mjg0NDkyMjCCASIwDQYJKoZIhvcNAQEBBQADggEP
ADCCAQoCggEBAJjFFdpJcy/Keh0gpEhXnruzSp+OTrt09vG8R5toHxRy0ZWbjK7DM+rjx04/AWDG
oHaNSpvPxU3fHESU2VUUVjPXui21A3FsHHZ6xSs+ILsbFnv2pg9SWNvXF6jpcJotVeIIB/Ln+mQb
iPBnWMonzWq+edMnAcm8ahXNrYax6m+JyNc6CdyMUpVouCCixkAMWm3Ku7VoKHdsIi3OX4ROdGKI
6kCKCHaVLSICHCQB2H0JdKuRB9B1rCS9C96P6DWSQ6sFwLWMDdm9zpe+ZVeV2nAWKlLsv2PKrSPK
zwaGzrKEPnNTFFolRaio3F5/5qY1lcDmLkV3lQ269CsqfgPNVukCAwEAAaOCAjYwggIyMCMGA1Ud
JQQcMBoGCCsGAQUFBwMCBggrBgEFBQcDBAYEVR0lADAfBgNVHSMEGDAWgBT+l1x3VbXH9nxQNBIC
g/nKm6XMtjA5BggrBgEFBQcBAQQtMCswKQYIKwYBBQUHMAGGHWh0dHA6Ly91c2Vycy5vY3NwLmQt
dHJ1c3QubmV0MF0GA1UdIARWMFQwUgYLKwYBBAGlNAKBSAEwQzBBBggrBgEFBQcCARY1aHR0cDov
L3d3dy5kLXRydXN0Lm5ldC9yZXBvc2l0b3J5L0NQU19DbGFzc18zXzJfMS5wZGYwgdEGA1UdHwSB
yTCBxjCBw6CBwKCBvYZ6bGRhcDovL2RpcmVjdG9yeS5kLXRydXN0Lm5ldC9DTj1ELVRSVVNUJTIw
QWR2YW5jZWQlMjBDbGFzcyUyMDIlMjBDQSUyMDIwMDcsTz1ELVRydXN0JTIwR21iSCxDPURFP2Nl
cnRpZmljYXRlcmV2b2NhdGlvbmxpc3SGP2h0dHA6Ly93d3cuZC10cnVzdC5uZXQvY3JsL2QtdHJ1
c3RfYWR2YW5jZWRfY2xhc3NfMl9jYV8yMDA3LmNybDAzBgNVHRIELDAqgRBpbmZvQGQtdHJ1c3Qu
bmV0hhZodHRwOi8vd3d3LmQtdHJ1c3QubmV0MB0GA1UdDgQWBBSKL7RPrzylTNKvJ2aJIq/mX2Ew
azAOBgNVHQ8BAf8EBAMCBLAwGAYDVR0RBBEwD4ENdGhpbGthQHZwcy5kZTANBgkqhkiG9w0BAQUF
AAOCAQEAFDzpVKX8EsEJssScG4fMgZq4+AlTdG7GNFJw3cW7EqIu/grU2qgCTyrw9vXOp6cpzD3H
jSpYZ4eUGHYGs1yF7VjoHdwXPjLdR3NUArnNSDeEMGfNIAWY/lZThr0Go2DXTjM7rmAumnp86/bc
JBRALYq1AOGTVXQ5qW548FuIMIvQ+9KN4clrBZMSRvEAFVtIAE8EpHPuLUITlpg7Q8b2gVCqmG38
2kUN0ISwyE8PR9kahO9WaktWMawYVeWn2LDR6GOCUwPip2RhDAmCqzHLWUrEBDcOMuwh+eFziICV
pDFM/kX3ES1yinyp8CFvlg0uinyPN9w449PBCSHfuVfzSTGCA2gwggNkAgEBMFYwTzELMAkGA1UE
BhMCREUxFTATBgNVBAoMDEQtVHJ1c3QgR21iSDEpMCcGA1UEAwwgRC1UUlVTVCBBZHZhbmNlZCBD
bGFzcyAyIENBIDIwMDcCAwdaiDAJBgUrDgMCGgUAoIIB5zAYBgkqhkiG9w0BCQMxCwYJKoZIhvcN
AQcBMBwGCSqGSIb3DQEJBTEPFw0wODExMTcwOTM4MjBaMCMGCSqGSIb3DQEJBDEWBBRb4dohhhYX
Xz0VYQuho03UUjDakjBlBgkrBgEEAYI3EAQxWDBWME8xCzAJBgNVBAYTAkRFMRUwEwYDVQQKDAxE
LVRydXN0IEdtYkgxKTAnBgNVBAMMIEQtVFJVU1QgQWR2YW5jZWQgQ2xhc3MgMiBDQSAyMDA3AgMH
WogwZwYLKoZIhvcNAQkQAgsxWKBWME8xCzAJBgNVBAYTAkRFMRUwEwYDVQQKDAxELVRydXN0IEdt
YkgxKTAnBgNVBAMMIEQtVFJVU1QgQWR2YW5jZWQgQ2xhc3MgMiBDQSAyMDA3AgMHWogwgbcGCSqG
SIb3DQEJDzGBqTCBpjALBglghkgBZQMEASowCwYJYIZIAWUDBAEWMAoGCCqGSIb3DQMHMAsGCWCG
SAFlAwQBAjAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcN
AwICASgwBwYFKw4DAhowCwYJYIZIAWUDBAIDMAsGCWCGSAFlAwQCAjALBglghkgBZQMEAgEwCgYI
KoZIhvcNAgUwDQYJKoZIhvcNAQEBBQAEggEAD1dN8PaSlq1iP/5BYMtV2peTXbQy0/FPjeN0acoY
jszIsHLkiGN0UVnA53OOU3ZP3z9gEvho9DHoR12zizWhFbeNB7e20SazC46MDaRqPVjKiQ2k52Nl
QpZC04fsmePAjO08mMOvZuL3Hpx7/Cm14gV8Z/Ddtwvsxo2WIztLApQF15FlgwIWwV/7tzJcr0f7
L2GNmgQGqbmf95cCFR636Fohso9Un0fuVkapS4dfBgJpXdbf4/Fp6K5l4C4124sh7la+I1mmMD/z
6e0kbtgPHRNW1EYl72BgMcZTMhcFng0h4RfG3oWYTNIJYrvjYE8H4g4jQuduj2kIN7VKqlJN9AAA
AAAAAA==

------=_NextPart_000_0045_01C948A0.9C00DFC0--