I think you need to specify that in the URL for the JDBC connection. http://dev.mysql.com/doc/refman/5.0/en/cj-configuration-properties.html
It's really a MySQL/JDBC configuration question. Hope this helps Keith -----Original Message----- From: Eitan Gur [mailto:[EMAIL PROTECTED] Sent: 27 June 2006 17:49 To: Ant Users List Subject: RE: SQL task - how to set collation (working with MySQL) Sure. If I use the console for example, I use: mysql -u[user] -p[password] --default-character-set=[charset] This causes the console client to use the corresponding charset, and by that - the corresponding collation (which is fine by me). So maybe my question was how to instruct ant to use a specific charset... Thanks Jan, Eitan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 5:39 PM To: user@ant.apache.org Subject: AW: SQL task - how to set collation (working with MySQL) Can you give an command line example for MySQL? Jan >-----Ursprüngliche Nachricht----- >Von: Eitan Gur [mailto:[EMAIL PROTECTED] >Gesendet: Dienstag, 27. Juni 2006 18:38 >An: Ant Users List >Betreff: RE: SQL task - how to set collation (working with MySQL) > >I think it is an Ant related question, as I only want to know >how to tell Ant to use a specific collation - I know how to do >this in other clients. For me, Ant is just another client, and >I would like to specify a parameter... > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Tuesday, June 27, 2006 5:34 PM >To: user@ant.apache.org >Subject: AW: SQL task - how to set collation (working with MySQL) > >>I wanted to know whether (and how) I can instruct ANT to use >a specific >>collation with the SQL task (specifically - when using MySQL). > > >Hhmm ... really an Ant related question or more SQL related? > > >Jan > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] For >additional commands, e-mail: [EMAIL PROTECTED] > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] For >additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
