iconv-error with encoding of mysql-database

Dominik Reusser <[email protected]>
Newsgroups gmane.text.refdb.general
Organization Uni Potsdam
Message-ID <[email protected]>
I've got problems with the encoding of the mysql database.
When importing ISO-8859-1 files, everything works fine. However, if I try to 
import an UTF-8 encoded file, I run into the following error.

SELECT meta_app,meta_type,meta_dbversion from t_meta
connected to database server using database:
hykli
input encoding is:
UTF-8
database encoding is:
ISO-8859-1
SELECT VERSION()
iconv: invalid input character sequence
character set conversion failed
command processing done, finish dialog now
error

-- 
Dominik Reusser
Universität Potsdam

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
Refdb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/refdb-users
refdb-bug.txt (text/plain, 1.9 KB)
Linux litdb 2.6.16-2-686 #1 Fri Aug 18 19:01:49 UTC 2006 i686 GNU/Linux
RefDB binaries and scripts in the path:
/usr/bin/refdbd
/usr/bin/refdba
/usr/bin/refdbc
/usr/bin/refdbib
/usr/bin/bib2ris
and their version numbers:
refdbd 0.9.8-pre5
refdba 0.9.8-pre5
refdbc 0.9.8-pre5
refdbib 0.9.8-pre5
/usr/bin/refdb-bug: line 41: nmed2ris: command not found
bib2ris 0.9.8-pre5
DSSSL engines in the path:
and their version numbers:

$REFDBLIB is /usr/share/refdb
global refdbd config file:
refdblib /usr/share/refdb
serverip	localhost
dbsport	3306
dbserver	mysql
dbpath		/var/lib/refdb/db
port	9734
logfile /var/log/refdbd.log
logdest file
loglevel info
pidfile		/var/run/refdbd.pid
remoteadmin f
remoteconnect f
keep_pnames t
keyword_scan t
db_encoding	utf8
in_encoding	UTF-8

global refdba config file:
serverip	127.0.0.1
port	9734
pager	less
username	joeuser
passwd	<protected>
logdest file
loglevel info
logfile /var/log/refdba.log

global refdbc config file:
serverip	127.0.0.1
port	9734
pager	less
username	joeuser
passwd	<protected>
logdest file
loglevel info
logfile /var/log/refdbc.log
cssurl /usr/share/refdb/css/refdb.css
fromencoding UTF-8
toencoding UTF-8

global refdbc config file (cgi):

global refdbib config file:

global nmed2ris config file:

global bib2ris config file:

$HOME is /home/admin
user refdba config file:

user refdba config file (hidden):
serverip        127.0.0.1
username        root
passwd          <protected>
pager           less
toencoding      ISO-8859-1
fromencoding    ISO-8859-1

user refdbc config file:

user refdbc config file (hidden):
serverip        127.0.0.1
username        root
passwd          <protected>
defaultdb       hykli
pager           less
toencoding      UTF-8
fromencoding    UTF-8

user refdbib config file:

user refdbib config file (hidden):

user nmed2ris config file:

user nmed2ris config file (hidden):

user bib2ris config file:

user bib2ris config file (hidden):
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.