Tags: app, database, default, defaults, final, forcing, microsoft, mysql, nvarchar, oracle, server, sql, sqldbtype, sqlparameter, strings, varchar

SqlParameter defaults to nvarchar for strings

On Database » Microsoft SQL Server

417 words with 1 Comments; publish: Sat, 05 Jan 2008 20:20:00 GMT; (250140.63, « »)

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.

All Comments

Leave a comment...

  • 1 Comments
    • There seems no way
      #1; Sat, 05 Jan 2008 20:21:00 GMT