MySql Backup

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

Groups:

Joined: 8/10/2009
Posts: 1,024
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
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
It seems this now fixed in the latest version :)
Alexander Omelchenko
#3 Posted : Friday, July 29, 2016 3:57:18 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 457
Yes, it is!
Forum Jump  
You cannot post new topics in this forum.
You cannot 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.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com