OK, I'm confused.

We have created lots of custom modules without problems. Until now.

We've just recently packaged up some changes to modules and created scripts for upgrades to the database. In a few instances we are getting syntax errors when trying to run the scripts, even though the same scripts run fine in SSMS.

I'm beginning to wonder whether the issue is related to the plus symbol (+), because that seems to be a bit of a common theme. We are in the UK and therefore running en-GB and Windows 1252 (if that's relevant). When the syntax error is raised, looking in detail at the error message the + is missing from the script reported.

Has anyone else come across this, and come up with a solution?

I've just tried switching to en-US during installation and it seems to make no difference.

We're running 04.09.05 and have SQL2008 for our database server, in case of anyone else suffering this and a pattern emerging.

Thanks Cathal, I appreciate the help. I'd never have guess that one.

To clarify, I assume you mean that DNN, or perhaps the Application Block, will strip them during processing, as the file saves correctly with the characters included.

Do you happen to know if an initial save in UTF-8 allows VS to recognise them as UTF-8 and will then preserve the encoding even when worked on in that environment? That would be a great help if it did, because it's only the very first time we create a file that we have to do anything different. Come on VS, help me out here!

Fingers crossed ...