- 論壇徽章:
- 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.
不過測(cè)試的時(shí)候，發(fā)現(xiàn)報(bào)錯(cuò)：Greenplum unicode converter truncated character.上網(wǎng)谷歌得下以下結(jié)果：
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.
現(xiàn)在有二個(gè)疑惑：
(1)有同樣操作的機(jī)器,使用相同的psqlodbcw.so驅(qū)動(dòng)的時(shí)候,沒有報(bào)錯(cuò)。因?yàn)镚P是UTF8的格式，使用datastage進(jìn)行連接�？刹豢赡苡衅渌牡胤�?jīng)]有設(shè)置到，導(dǎo)致報(bào)的這個(gè)錯(cuò)？
(2)如果上述猜測(cè)不正確的話,需要怎么樣才能編譯出--disable-unicode的psqlodbcw.so文件? |
|
免費(fèi)注冊(cè)
發(fā)表于 2012-06-13 19:47