search

timabell / sqlHawk

Database management / migration tooling. Java / JDBC based.
http://timabell.github.com/sqlHawk/
GNU General Public License v3.0
8 stars 4 forks source link

scm - utf-16 support for scm files (unicode / utf8) #15

Open timabell opened 12 years ago

timabell commented 12 years ago

utf-16 support for scm files - byte order marker (BOM) causes problems running scripts & stored procs

If you have a script with no special characters you can work around this limitation by changing the encoding of your file to ansi codepage 1252. (Use notepad++, advanced save options in visual studio, or the tiny dropdown next to save in the ssms save as dialog)

The symptoms are scripts failing with sql errors of "incorrect syntax near X" where X is an odd character.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

timabell commented 12 years ago

note this also messes with git see also issue #7

timabell commented 9 years ago

should spit out utf8+bom files, which work nicely with git and handle extended chars