search

prabhu2289 / roundhouse

Automatically exported from code.google.com/p/roundhouse
0 stars 0 forks source link

Scripts with Unicode #81

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
Running the following within a sql script, against a Sql Server database, 
appears to cause the Unicode data to be transformed to another format:

UPDATE [Table] SET [Column] = N'渣打银行优势测试' WHERE [ID] = XXX;

The update statement is attempting to update a column to hold a Mandarin 
string. I have tested the script using Sql Server Management Studio which is 
successful but unfortunately this does not execute as expected when ran through 
RoundHouse.

Am I missing something obvious or is this an issue?

Thanks,

Colin

Original issue reported on code.google.com by capp.jo...@gmail.com on 3 Sep 2014 at 12:14

GoogleCodeExporter commented 8 years ago 
Apologies forgot to mention the following:

1. Round House Version = 0.8.6.0
2. Sql Server Version = 2008 and 2012
3. Operating System = Windows - Server and Desktop

Original comment by capp.jo...@gmail.com on 3 Sep 2014 at 12:25