Re: Microsoft SQLServer - varchar or nvarchar fields?

The application is multilingual and I've set the collation of SQL Server to
latin1
I'm tempted to use nvarchar (because jtds driver seems to send strings as
unicode), but I don't know:
1) How this will impact on performances of the application.
2) If I have to use a different sintax on my queries (for example using
N'xxxxxx' instead of 'xxxxxxx' for strings)
3) Any other issues on using nvarchar

Thanks,
Davide.



.

Relevant Pages

  • Re: JDBC - varchar or nvarchar fields?
    ... I'm tempted to use nvarchar (because jtds driver seems to send strings as ...
    (comp.databases.ms-sqlserver)
  • Re: stored procedure question
    ... > I pass a stored procedure 2 strings: ... but it is looking for StringVal to be an INT ... > @StringVal1 nvarchar, ... > declare @NextString1 nvarchar ...
    (microsoft.public.sqlserver.programming)
  • Re: Anger, Rage, Confusion...
    ... > declared in the vb code as strings yet the parameters are declared as ... You can use an overload of the SqlParameter constructor that takes also the size ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Premature end of regular expression with non-ascii chara
    ... > is that I would like to work in UTF-8, but I have to read in files. ... > a way of converting these strings to Unicode in Ruby. ... My solution has been to convert a string from latin1 or ... and the other way round with ...
    (comp.lang.ruby)
  • Re: Convert to DateTime
    ... A straightforward way is to add a new datetime column to the table, ... and run a succession of update queries from the old nvarchar to the new. ... there are still strings that will convert to date and time ...
    (microsoft.public.sqlserver.programming)