A reply to : [email protected]
I had a similar problem since I had .mdb files containing cyrillic characters
which I wanted to upload to a mysql database.
I could upload them but then I only got unreadable characters from the mysql
database either in knoda or in Openoffice base program.
It turned out that Mysql was compiled on my distribution (Slackware) with
latin1 charset as the internal and default charset of the database daemon -> so
I had to reconfigure and recompile the Mysql package with the following
configure options :
$ ./configure --prefix=/usr --enable-assembler --with-extra-charsets=all
--with-charset=utf8 --enable-thread-safe-client --with-csv-storage-engine
--with-archive-storage-engine --with-example-storage-engine
--with-blackhole-storage-engine --with-federated-storage-engine
--with-openssl-libs=/usr/lib --with-openssl-includes=/usr/include
--with-openssl=/usr
in order to get it working properly. The important part is --with-charset=utf8
!
And then in the configuration file of the mysql daemon - /etc/my.cnf I put
"default-character-set=utf8" under the [mysqld] and
[client] sections .
And in the start up script for the mysqld I have the following startup options :
$ /usr/bin/mysqld_safe --default-character-set=utf8
--pid-file=/var/run/mysql/mysql.pid $SKIP &
The important part is --default-character-set=utf8 !
This seemed to sort out my problems with charsets.
I hope this can be of any help.
Cheeers,
Todor
_________________________________________________________________
Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.
http://www.microsoft.com/windows/windowslive/products/photos.aspx
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
