SQLite中获得的中文无法正常显示

chiron_shen

_SQLite_FetchData 从数据库中查询到的中文在autoit中显示乱码 这个有办法解决吗？

netegg

回复 1# chiron_shen
没问题啊

netegg

[au3]#include <SQLite.au3>
#include <SQLite.dll.au3>
#include <GuiConstantsEx.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>

Global $edit

_Main()

Func _Main()

  Local $GUI, $hQuery, $aRow, $aNames

  $GUI = GUICreate("SQLite FetchData", 400, 260)
  $edit = GUICtrlCreateEdit("", 2, 2, 394, 256, BitOR($ES_READONLY, $ES_AUTOVSCROLL))
  GUISetState()

  _SQLite_Startup ()
  MemoWrite("_SQLite_LibVersion=" &_SQLite_LibVersion() & @CR)
  _SQLite_Open () ; 打开:内存:数据库
  _SQLite_Exec (-1, "CREATE table aTest (a,b,c);")
  _SQLite_Exec (-1, "INSERT INTO aTest(a,b,c) VALUES ('中','2','国');")
  _SQLite_Exec (-1, "INSERT INTO aTest(a,b,c) VALUES ('b','3',' ');")
  _SQLite_Exec (-1, "INSERT INTO aTest(a,b,c) VALUES ('a','1','Hello');")
  _SQlite_Query (-1, "SELECT ROWID,* FROM aTest ORDER BY a;", $hQuery)
  _SQLite_FetchNames ($hQuery, $aNames)
  MemoWrite(StringFormat(" %-10s  %-10s  %-10s  %-10s ", $aNames[0], $aNames[1], $aNames[2], $aNames[3]) & @CR)
  While _SQLite_FetchData ($hQuery, $aRow) = $SQLITE_OK ; 读出下一行
    MemoWrite(StringFormat(" %-10s  %-10s  %-10s  %-10s ", $aRow[0], $aRow[1], $aRow[2], $aRow[3]) & @CR)
  WEnd
  _SQLite_Exec (-1, "DROP table aTest;")
  _SQLite_Close ()
  _SQLite_Shutdown ()

  ; 循环至用户退出
  Do
  Until GUIGetMsg() = $GUI_EVENT_CLOSE
  GUIDelete()
EndFunc   ;==>_Main

Func memowrite($s_text)
  GUICtrlSetData($edit, $s_text & @CRLF, 1)
EndFunc   ;==>memowrite[/au3]

netegg

[au3]#include <SQLite.au3>
#include <SQLite.dll.au3>
#include <GuiConstantsEx.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>

Global $edit

_Main()

Func _Main()

  Local $GUI, $hQuery, $aRow, $aNames

  $GUI = GUICreate("SQLite FetchData", 400, 260)
  $edit = GUICtrlCreateEdit("", 2, 2, 394, 256, BitOR($ES_READONLY, $ES_AUTOVSCROLL))
  GUISetState()

  _SQLite_Startup ()
  MemoWrite("_SQLite_LibVersion=" &_SQLite_LibVersion() & @CR)
  _SQLite_Open () ; 打开:内存:数据库
  _SQLite_Exec (-1, "CREATE table aTest (a,b,c);")
  _SQLite_Exec (-1, "INSERT INTO aTest(a,b,c) VALUES ('中','2','国');")
  _SQLite_Exec (-1, "INSERT INTO aTest(a,b,c) VALUES ('b','3',' ');")
  _SQLite_Exec (-1, "INSERT INTO aTest(a,b,c) VALUES ('a','1','Hello');")
  _SQlite_Query (-1, "SELECT ROWID,* FROM aTest ORDER BY a;", $hQuery)
  _SQLite_FetchNames ($hQuery, $aNames)
  MemoWrite(StringFormat(" %-10s  %-10s  %-10s  %-10s ", $aNames[0], $aNames[1], $aNames[2], $aNames[3]) & @CR)
  While _SQLite_FetchData ($hQuery, $aRow) = $SQLITE_OK ; 读出下一行
    MemoWrite(StringFormat(" %-10s  %-10s  %-10s  %-10s ", $aRow[0], $aRow[1], $aRow[2], $aRow[3]) & @CR)
  WEnd
  _SQLite_Exec (-1, "DROP table aTest;")
  _SQLite_Close ()
  _SQLite_Shutdown ()

  ; 循环至用户退出
  Do
  Until GUIGetMsg() = $GUI_EVENT_CLOSE
  GUIDelete()
EndFunc   ;==>_Main

Func memowrite($s_text)
  GUICtrlSetData($edit, $s_text & @CRLF, 1)
EndFunc   ;==>memowrite[/au3]

netegg

不对，你用的sqlite是什么版本

chiron_shen

谢谢你，我用的版本是3.8.9 看了你上面代码我验证了下，发现用autoit的函数写进去的中文是可以显示的，我一直不能显示的是在windows 命令模式下写入的中文 ，比如我用.import 导入一个csv文件中有中文，这时用autoit 获取出来就是乱码

netegg

哦，那个需要转码，windows 命令行里的中文字没法直接用

caianhua1986

回复 6# chiron_shen
要用Unicode编码的UTF8。中文系统默认的是ANSI。直接是乱码。