NH docs would be a good place to look http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/mapping.html#mapping-types-basictypes
On Wed, Feb 25, 2009 at 9:16 PM, jasonsirota <[email protected]> wrote: > > I found the answer from a colleague, "AnsiString" but I still can't > find the actual <i>list</i> > > On Feb 25, 11:05 am, jasonsirota <[email protected]> wrote: >> By default, AR is passing string properties as nvarchar instead of >> varchar, my SQL Server 2000 existing database uses varchar as its >> string type and is causing a full-table scan on the query. >> >> Is there any way to force AR/NH to pass varchar instead of nvarchar. >> >> What it's currently passing: >> exec sp_executesql N'SELECT [QUERY] WHERE this_.member = @p0', N'@p0 >> nvarchar(11)', @p0 = N'01130004903' >> >> What I would like it to pass: >> exec sp_executesql N'SELECT [QUERY] WHERE this_.member = @p0', N'@p0 >> varchar(11)', @p0 = '01130004903' >> >> Is there a document somewhere of the NHibernate Types to SQL Server >> columns? >> >> Jason > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
