postgresql - Clojure jdbc postgres : Why do the results from my query return unicode characters in table names as �?

Question

我的表名是 pinkƒpink1，当我通过 select 时

   (sql/with-query-results res
     "select pinkƒpink1.growth555 as pinkƒpink1$growth555, pinkƒpink1.status_id as pinkƒpink1$status_id, pinkƒpink1.status_position as pinkƒpink1$status_position, pinkƒpink1.i1l0 as pinkƒpink1$i1l0, pinkƒpink1.f∆ as pinkƒpink1$f∆, pinkƒpink1.env_id as pinkƒpink1$env_id, pinkƒpink1.position as pinkƒpink1$position, pinkƒpink1.created_at as pinkƒpink1$created_at, pinkƒpink1.locked as pinkƒpink1$locked, pinkƒpink1.updated_at as pinkƒpink1$updated_at, pinkƒpink1.id as pinkƒpink1$id from pinkƒpink1 as pinkƒpink1 where pinkƒpink1.id in (select * from (select pinkƒpink1.id from pinkƒpink1 order by pinkƒpink1.position asc) as _conditions_) order by pinkƒpink1.position asc"
     (doall res))

结果全乱了:

{:pink�pink1$id 1, :pink�pink1$status-position 0, :pink�pink1$updated-at #inst "2013-06-27T21:58:01.711000000-00:00", :pink�pink1$status-id 1, :pink�pink1$growth555 1.3333388822M, :pink�pink1$env-id 1, :pink�pink1$i1l0 YELLL, :pink�pink1$position 0, :pink�pink1$created-at #inst "2013-06-27T21:58:01.712084000-00:00", :pink�pink1$f∆ 55555, :pink�pink1$locked false}

知道发生了什么事吗？我在 OSX 10.8.2 上。

Answer 1

似乎 repl 在将关键字打印到屏幕时正在处理名称。也许您可以尝试将结果吐到一个文件中，然后在您信任的具有 unicode 支持的编辑器中打开它。

您也可以尝试在查询中设置 :keywordize-keys false 以防止这种转换