[MonetDB-users] charset problem with the odbc driver for windows
hello, all, i installed monetdb in windows server 2008(64bit) , and installed the odbc for windows( 32bit intalled firstly, and 64bit the next), after insert some Chinese characters, i use oracle biee to show the table data, but biee can't show all the characters, just like below:
1��monetdb data showed in biee i also install mysql to test this, the database character set is utf8 too, and biee can show the data correctly:
2��mysql data showed in biee
the data showed in command line tool are the same from monetdb and mysql
monetdb command line tool return: sql>select * from test2; +------+ | nam | +======+ | 广州 | | 梅州 | +------+ 2 tuples (2.189ms)
mysql commad line tool return: mysql> select * from test; +--------+ | nam | +--------+ | 广州 | | 梅州 | +--------+ 2 rows in set (0.00 sec)
Does this mean that: the odbc driver of monetdb has some problems?
It is possible that there is a bug in the MonetDB ODBC driver. Please turn this into a bug report a http://bugs.monetdb.org/.
On 2012-06-18 07:20, liangmeng wrote:
hello, all, i installed monetdb in windows server 2008(64bit) , and installed the odbc for windows( 32bit intalled firstly, and 64bit the next), after insert some Chinese characters, i use oracle biee to show the table data, but biee can't show all the characters, just like below: 1）monetdb data showed in biee i also install mysql to test this, the database character set is utf8 too, and biee can show the data correctly: 2）mysql data showed in biee
the data showed in command line tool are the same from monetdb and mysql
monetdb command line tool return: sql>select * from test2; +------+ | nam | +======+ | 骞垮窞 | | 姊呭窞 | +------+ 2 tuples (2.189ms)
mysql commad line tool return: mysql> select * from test; +--------+ | nam | +--------+ | 骞垮窞 | | 姊呭窞 | +--------+ 2 rows in set (0.00 sec)
Does this mean that: the odbcdriver of monetdb has some problems?
Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
liangmeng -
Sjoerd Mullender