postgresql copy UNICODE txt 问题。
d[@more@]
从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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9697/viewspace-1044946/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
