- 论坛徽章:
- 0
|
使用greenplum-connectivity-3.3.7-build-1-RHEL3-i386.bin来安装postgresql odbc driver,路径如下/usr/local/greenplum-connectivity-3.3.7.0-build-1/drivers/odbc/psqlodbc-08.04.0200/unixodbc-2.2.12/psqlodbcw.so.
不过测试的时候,发现报错:Greenplum unicode converter truncated character.上网谷歌得下以下结果:
When psql odbc driver is built normally it creates psqlodbcw.so. If we use this driver with DataStage, it shows "Unicode Converter buffer overflow" error with DataDirect Driver Manager. Workaround for this issue is to build the the non-unicode version of the driver with ‘--disable-unicode’ option. This will create psqlodbca.so driver.
现在有二个疑惑:
(1)有同样操作的机器,使用相同的psqlodbcw.so驱动的时候,没有报错。因为GP是UTF8的格式,使用datastage进行连接。可不可能有其它的地方没有设置到,导致报的这个错?
(2)如果上述猜测不正确的话,需要怎么样才能编译出--disable-unicode的psqlodbcw.so文件? |
|