search

chucknorris / roundhouse

RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control
http://projectroundhouse.org
916 stars 249 forks source link

text_of_script missing special characters, converting to question marks when entered into SQL Server DB #404

Closed bpercy11 closed 3 years ago

bpercy11 commented 4 years ago

Consider a script in the runBeforeUp folder that contains a string that holds a special character, like the ohm symbol (Ω). After roundhouse executes this script and upon insertion of the script contents into the the [RoundhousE].[ScriptsRun].[text_of_script] column, the ohm symbol is dropping information (bytes) associated with it and is then being entered as a question mark (?).

This could possibly be due to the text_of_script column being of type text instead of nvarchar. I have not located in the roundhouse src code exactly where this problem could be alleviated just yet.

erikbra commented 4 years ago

Thank you for reporting.

A couple of questions:

  1. Which encoding is the text file stored in? UTF-8 or something else?
  2. Which database are you connecting to?
  3. Do you have a simple repro that demonstrates the problem?
erikbra commented 4 years ago

@bpercy11 do you have anything more to add to this issue? If not, I will have to close it.

erikbra commented 3 years ago

Closing due to lack of response.