Yeah, I just made the same hack and it worked, even though it seems "dirty" to me the same!
The "funny" thing is that if you look at the SQL statements generated by Torque for MSSQL, in the table cursor creation part (the first part of the .sql), nvarchar(60) is used! Probably because this is template code taken from somewhere else. Anyway, I think I'll work with VARCHAR, which will let me be a bit more compatible with outer world... Thanks for the suggestion! Giulio Vezzelli Infolog S.r.l. Via Alfieri, 28 Modena - 41100 Telefono : +39-059-822446 Sito web : http://www.infolog.it E-mail : [EMAIL PROTECTED] > -----Messaggio originale----- > Da: William Kemper [mailto:[EMAIL PROTECTED] > Inviato: gioved� 23 ottobre 2003 23.29 > A: Apache Torque Users List > Oggetto: Re: NVARCHAR type for MSSQL > > > I had the same problem so I just hacked up db.props in > templates/sql/base/mssql. It's not really a solution because > it just makes > all VARCHAR columns into NVARCHAR, but it works. I think > Torque doesn't > 'appear' to support NVARCHAR because there is no > corresponding JDBC data > type, and of course, Java is smart enough already to > understand 2 byte > characters. You could check out > http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/mapping. html#996857 for a brief discussion of JDBC types. > I tried to specify the NVARCHAR column type in project-schema.xml and > Torque failed to build the objects... > > Doesn't Torque support NVARCHAR columns ? Do I have to manually tweak > Torque to let it build the objects ? If so, I'd consider submitting a > patch to enable Torque to do so... > > Giulio Vezzelli > Infolog S.r.l. > Via Alfieri, 28 > Modena - 41100 > Telefono : +39-059-822446 > Sito web : http://www.infolog.it <http://www.infolog.it/> E-mail : > [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
