Noticed 3 strange control chars when automating mysql scripts with the latest Norma tool.
EF BB BF ??? These control chars don't appear in notepad or any standard visual studio editors in windows. However, the following environments see the 3 control chars vividly, mysql, linux vi or emacs editor, etc... Doesn't look like this is a feature.
In mysql the error I get when I run a batch command is as follows:
C:\Users\marc\Documents\Visual Studio 2008\Projects\baameh.com\BahLib\mdl>echo off
Enter password: *******
ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use n
ear '
CREATE TABLE `User`
(
userId INT AUTO_INCREMENT NOT NULL,
emailName VARCHA' at line 1
C:\Users\marc\Documents\Visual Studio 2008\Projects\baameh.com\BahLib\mdl>
This is the batch command:
C:\Users\marc\Documents\Visual Studio 2008\Projects\baameh.com\BahLib\mdl>type runme.bat
echo off
del happy.sql
type ".\app.txt" > ".\happy.sql"
type ".\baameh.MySQL.sql" >> ".\happy.sql"
mysql -u root -p < ".\happy.sql"
:) hunting,
Marc