Issue #190 has been reported by Lanore Ronan.
----------------------------------------
Bug #190: utf-8 and import csv
http://tools.lsc-project.org/issues/show/190
Author: Lanore Ronan
Status: New
Priority: Low
Assigned to:
Category: Core
Target version:
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
