Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
When creating INSERT commands in script for nchar and nvarchar fileds Options · View
Adin
#1 Posted : Wednesday, May 26, 2010 8:59:45 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 610
The script created needs to add the letter N before string of the text being inserted when the field type is nchar or nvarchar. For example, currently the program creates:

INSERT INTO [dbo].[MyTable] ([ID], [SomeField]) VALUES (14 'Text in foreign tongue')
it should be:
INSERT INTO [dbo].[MyTable] ([ID], [SomeField]) VALUES (14 N'Text in foreign tongue')

Otherwise all the inserted text turns into question marks when inserting none English text (Tried with Hebrew and Arabic)

I did not find a setting that fixes this.
Guest
#2 Posted : Monday, January 23, 2012 5:43:09 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 610
It seems this now fixed in the latest version :)
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.