Problem with Locale and SQL task

[Paul Keeble <cs...@yahoo.co.uk>]

I am having some problems loading unicode using the SQL task with Ant 1.6.5 on
JDK 1.4.on Linux. The database is MS SQL. When the scripts are run from the
linux the internaitionl characters (sample below) are replaced with a ?. The
database is set to use utf-8 encoding.

When connecting via the Enterprise Manager the same scripts load normally, so
it is something to do with Ant + JDBC.

A sample insertion data that would be in the sql script that shows the problem:

INSERT INTO dbo.TABLE(KeyName,Locale,Value) VALUES('Key','de','Allgemeine
Geschäftsbedingungen');

In the database under column value after running the sql task the entry would
read: 
Allgemeine Gesch?ftsbedingungen

Nothing special is being done in the sql task - its simply as follows:

<sql classpathref="database.classpath"
  driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" 
  url="${db.connection.url}" 
  autocommit="true"
  delimiter="GO"
  delimitertype="row"
  src="myfile.sql"
  userid="..."
  password="..."/>

What am I doing wrong here, are their additional settings I need on the sql
statement or do I need to go through and replace these characters with \u....
etc?

Paul


	
	
		
___________________________________________________________ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org

Re: Problem with Locale and SQL task

[Ivan Ivanov <ra...@yahoo.com>]

Hello Paul,

<sql> task has "encoding" attribute. You may find it
helpful.

I understand from your message that your database uses
UTF-8. What  is the encoding, however, of the system
on which you start the build script? Is there a
difference between the encoding of the file containing
the sql commands and the encoding of your Linux
system?

Regards
Ivan

--- Paul Keeble <cs...@yahoo.co.uk> wrote:

> I am having some problems loading unicode using the
> SQL task with Ant 1.6.5 on
> JDK 1.4.on Linux. The database is MS SQL. When the
> scripts are run from the
> linux the internaitionl characters (sample below)
> are replaced with a ?. The
> database is set to use utf-8 encoding.
> 
> When connecting via the Enterprise Manager the same
> scripts load normally, so
> it is something to do with Ant + JDBC.
> 
> A sample insertion data that would be in the sql
> script that shows the problem:
> 
> INSERT INTO dbo.TABLE(KeyName,Locale,Value)
> VALUES('Key','de','Allgemeine
> Geschäftsbedingungen');
> 
> In the database under column value after running the
> sql task the entry would
> read: 
> Allgemeine Gesch?ftsbedingungen
> 
> Nothing special is being done in the sql task - its
> simply as follows:
> 
> <sql classpathref="database.classpath"
>  
>
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
> 
>   url="${db.connection.url}" 
>   autocommit="true"
>   delimiter="GO"
>   delimitertype="row"
>   src="myfile.sql"
>   userid="..."
>   password="..."/>
> 
> What am I doing wrong here, are their additional
> settings I need on the sql
> statement or do I need to go through and replace
> these characters with \u....
> etc?
> 
> Paul
> 
> 
> 	
> 	
> 		
>
___________________________________________________________
> 
> Yahoo! Messenger - NEW crystal clear PC to PC
> calling worldwide with voicemail
> http://uk.messenger.yahoo.com
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> user-unsubscribe@ant.apache.org
> For additional commands, e-mail:
> user-help@ant.apache.org
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org