UTF-8 Files with byte order mark are not handled correctly

what is BOM? can you scale down small pom file that can reproduce the issue?

http://en.wikipedia.org/wiki/Byte-order_mark

Unicode files can use the first byte of the file to signify that it is in fact a unicode file.. the whole thing is a mess, sorry to drag you into character encoding hell, but we are almost totally out. =)

A simple test case is attached. Edit the pom for your DB config. The first test that does not have the byte order mark passes. However, the second test fails on the mark, it would be sweet if the plugin knew to skip it.

There is a lot of inconsistency right now regarding the BOM. Certian tools are practically forcing us to use the mark, but at the exact same time, the same people that are saying "it's good, we want you to use it", the other half of their tools don't support.. go figure

quick outline of fix:

void sendSQLFile() {
boolean isUnicode = config.encoding. != null && config.encoding.substring(0, 3) == "UTF";
char c = readTheFirstCharOfFile();
if (c == 0xFEFF&& isUnicode && config.unicodeFilesHaveByteOrderMark)

readRestOfFile();
}

This seems to have been fixed earlier, see the encoding parameter added in 1.1.
But I added a default value of project.build.sourceEncoding: http://docs.codehaus.org/display/MAVENUSER/POM+Element+for+Source+File+Encoding

Not sure what the fix was but having the same issue with 1.5.
Tried to set both <encoding> for the execution and <project.build.sourceEncoding> for the project to UTF-8.
Still get the error like

[INFO] Executing file: C:\Users\MATYUK~1\AppData\Local\Temp\init.1014934885sql
[ERROR] Failed to execute: ?DROP INDEX IF EXISTS idx_money_data_date

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 10.486s
[INFO] Finished at: Mon Dec 05 14:33:21 EST 2011
[INFO] Final Memory: 9M/23M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.codehaus.mojo:sql-maven-plugin:1.5:execute (preparedb) on project money: Syntax error in SQL statement " ?DROP[*] INDEX IF EXISTS IDX_MONEY_DATA_DATE "; SQL statement:
[ERROR] ?DROP INDEX IF EXISTS idx_money_data_date [42000-161]

The plugin is configured like this:

<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<version>1.5</version>

<dependencies>
<!-- specify the dependent JDBC driver here -->
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.3.161</version>
</dependency>
</dependencies>

<!-- common configuration shared by all executions -->
<configuration>
<driver>org.h2.Driver</driver>
<url>jdbc:h2:file:./db/moneydb</url>
<username>sa</username>
<password></password>
<srcFiles>
<srcFile>src/main/resources/init.sql</srcFile>
<srcFile>src/main/resources/expense.sql</srcFile>
<srcFile>src/main/resources/income.sql</srcFile>
</srcFiles>
<encoding>UTF-8</encoding>
</configuration>
<executions>
<execution>
<id>preparedb</id>
<phase>package</phase>
<goals><goal>execute</goal></goals>
<configuration>
<encoding>UTF-8</encoding>
</configuration>
</execution>
</executions>
</plugin>

The H2 is UTF-8 by default, so it doesn't seem to be the driver's issue.

please create a new issue (this one is already closed for a released version) and attach the file containing this statement. And just to be sure: use the output of mvn -v for the field environment