Issue #190 has been updated by Jonathan Clarke. Status changed from Feedback to Closed
---------------------------------------- Bug #190: utf-8 and import csv http://tools.lsc-project.org/issues/show/190 Author: Lanore Ronan Status: Closed Priority: Low Assigned to: Jonathan Clarke Category: Sample Target version: 1.2.0 On import csv batch the utf-8 is not supported here is my patch --- /root/lsc/sample/bin/lsc-sample 2010-03-25 22:45:00.000000000 +0100 +++ bin/lsc-import 2010-04-12 19:50:41.000000000 +0200 @@ -129,7 +129,12 @@ let nblines-- tail -n $nblines $1 > $HSQLDB_DIR/`basename $1` sep=`hsqldb_checkCsvSeparator $2` - hsqldb_sqlQuery "SET TABLE $HSQLDB_TABLE SOURCE \"`basename $1`;fs=$sep\"; SHUTDOWN;" > /dev/null 2>&1 + encoding=`file $1 | cut -d' ' -f2` + if [ "x$encoding" == "xUTF-8" ] ;then + hsqldb_sqlQuery "SET TABLE $HSQLDB_TABLE SOURCE \"`basename $1`;fs=$sep;encoding=UTF-8\"; SHUTDOWN;" > /dev/null 2>&1 + else + hsqldb_sqlQuery "SET TABLE $HSQLDB_TABLE SOURCE \"`basename $1`;fs=$sep\"; SHUTDOWN;" > /dev/null 2>&1 + fi if [ $? -eq 0 ]; then echo "$nblines lines added to table $HSQLDB_TABLE" return -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://tools.lsc-project.org/my/account
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-dev mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-dev
