postgresql copy UNICODE txt 问题。
时间:2011-01-20 来源:suzhouclark
d
从sqlserver 2005 导出的unicode的格式的txt.无法直接用copy导入到linux上的postgersql.
解决办法:
In adition of set the local encoding (Client and Server), if you are
runnning +nix there is a command called iconv that let you convert
from one charset to another. Always i used it, i never had any problems.
iconv -f UNICODE -t UTF-8 location.txt -o 1location.txt
相关阅读 更多 +