Tags: app, database, default, defaults, final, forcing, microsoft, mysql, nvarchar, oracle, server, sql, sqldbtype, sqlparameter, strings, varchar
SqlParameter defaults to nvarchar for strings
We've got an app that is in final testing so we can't go around forcing SqlDbType.VarChar. Is there any way to make SqlParameter default to varchar if you don't explicitly set a type for a string value? It's bad for our db index usage because they're all varchar and nvarchar forces a convert_implicit messing up performance.
Leave a comment...
- 1 Comments
- There seems no way#1; Sat, 05 Jan 2008 20:21:00 GMT