On Sep 5, 1:12 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Danny (adler.da...@gmail.com) writes:
> > I have a varchar(255) column for storing text in english and in
> > hebrew.
> > It was a stupid mistake to set the data type to be varchar, because
> > now I need to store text in german and francais too.
>
> > Question: Is it safe to change the data type from varchar to nvarchar,
> > without damaging the data that's already present?
> > (I have more than 1000000 records stored...)
>
> Provided that the collation of the column is a Hebrew collation, yes.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Thanks you guys.

Danny