从 PostgreSQL 导出的编码问题
我正在运行一个查询并从 PostgreSQL 导出数据。当我在写字板或 Excel 中打开它时,我最终得到了大量字符来代替撇号等。坦白说,我无法在任何这些编码废话上取得进展。当我导出数据时如何让这些字符正确显示?
I've got a query I'm running and exporting the data from PostgreSQL. I'm ending up with a ton of  characters in place of apostrophes and such when I open it in Wordpad or Excel. Quite frankly, I can't get my ahead around any of this encoding crap. How when I'm exporting the data do I get those characters to show right?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
我按照这里的说明进行操作,它做到了。不管怎样谢谢大家。
http://www.wohill.com/a-workaround- for-encoding-problems-in-excel/
I followed the instructions here and it did it. Thanks everyone anyway.
http://www.wohill.com/a-workaround-for-encoding-problems-in-excel/