postgresql copy UNICODE txt 問題。

suzhouclark發表於2011-01-20
SQLUnicode
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部落格 ” ，連結：http://blog.itpub.net/9697/viewspace-1044946/，如需轉載，請註明出處，否則將追究法律責任。
                                            


                




相關文章