Hi:
I am a user of ant 1.3. I use ant to install some of the user defined sql files
into mysql database. I list this define as below.
The scripts works well with english sql files. Some part of sql have chinese
charactors. The chinese charactors are in a mess in database. It seems that ant can
not handle double bytes. (The sql itsself can be installed into mysql correctly by
using mysql < abc.sql)
Has anyone met this problem?
------------------The build.xml file-------------------------------
<target name="modeling">
<antcall target="insert-sql-file">
<param name="sqlFile" value="${model}/1-initmenu.sql"/>
</antcall>
</target>
<target name="insert-sql-file">
<sql
driver="${databaseDriver}"
url="${databaseUrl}"
userid="${databaseUser}"
password="${databasePassword}"
src="${sqlFile}"
autocommit="true"
onerror="continue"
>
<classpath refid="classpath"/>
</sql>
</target>
------------------The sql file-------------------------------
insert into MENUITEM (ID, TITLE,CODE,PARENTCODE) values (2, '<some chinese
Charactor>','010100','010000');