notepad sql Unicode and Non Unicode

Posted by RBrattas on Super User See other posts from Super User or by RBrattas
Published on 2010-03-12T02:06:45Z Indexed on 2010/03/12 2:07 UTC
Read the original article Hit count: 712

Filed under:

sql-server-2005

Hi,

I have a Microsoft Notepad flate file with data and Vertical Bar as column delimiter.

I get following message: cannot convert between unicode and non-unicode string data types

It seems it is my nvarchar(max) that creates my problem.

I changed to varchar(max); but still the same problem.

How do I insert my flate file into my SQL Server 2005?

And in the SQL Server 2005 import and export wizard the flate file source advanced tab the OutputColumnWith is 50. Will that say my flate file column is max 50? I hope not because my column is more then 50...

Thank you, Rune

notepad sql Unicode and Non Unicode

Posted by RBrattas on Stack Overflow See other posts from Stack Overflow or by RBrattas
Published on 2010-03-12T02:06:45Z Indexed on 2010/03/12 9:37 UTC
Read the original article Hit count: 712

Filed under:

sql-server-2005

Hi,

I have a Microsoft Notepad flate file with data and Vertical Bar as column delimiter.

I get following message: cannot convert between unicode and non-unicode string data types

It seems it is my nvarchar(max) that creates my problem.

I changed to varchar(max); but still the same problem.

How do I insert my flate file into my SQL Server 2005?

And in the SQL Server 2005 import and export wizard the flate file source advanced tab the OutputColumnWith is 50. Will that say my flate file column is max 50? I hope not because my column is more then 50...

Thank you, Rune

notepad sql Unicode and Non Unicode

Posted by RBrattas on Stack Overflow See other posts from Stack Overflow or by RBrattas
Published on 2010-03-12T01:45:53Z Indexed on 2010/03/12 1:47 UTC
Read the original article Hit count: 712

Filed under:

sql

Hi,

I have a Microsoft Notepad flate file with data and Vertical Bar as column delimiter.

I get following message: cannot convert between unicode and non-unicode string data types

It seems it is my nvarchar(max) that creates my problem.

I changed to varchar(max); but still the same problem.

And in the SQL Server 2005 import and export wizard the flate file source advanced tab the OutputColumnWith is 50. Will that say my flate file column is max 50? I hope not because my column is more then 50...

Thank you, Rune

Developer IT