[Hibernate] MS SQL performance and Unicode

2003-08-20 Thread Gary Evesson
Am I the only person in the world who didn't know what happens if you use VARCHAR's with Java and the MS SQL JDBC driver? It seems unlikely because I can find no mention of this in the list archives or the like. If you use VARCHARs for database tables and index those columns either (as a primar

Re: [Hibernate] MS SQL performance and Unicode

2003-08-26 Thread Gary Evesson
Eric Pugh wrote: Also, I am working on this little issue, and I wanted to verify that the sendStringParametersAsUnicode=false string goes into the URL that you use to connect to the database, correct? jdbc:microsoft:sqlserver://[server]:1433;DatabaseName=[database name;SelectMethod=cursor;sendStri

Re: [Hibernate] MS SQL performance and Unicode

2003-08-26 Thread Gary Evesson
Serge Knystautas wrote: Eric Pugh wrote: No, I can chime in, that I as well didn't know this. Out of curiosity, has anyone put together a unit test that I could run to demo the differences? Would this be something to add to hibernate, or is it too random? What kind of difference are you look