Announcement

Collapse
No announcement yet.

when i import a json file into sqlite table it garble

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • when i import a json file into sqlite table it garble

    when i import a json file into sqlite table it garble

    json data:
    {"id":846613,"sitename":"仪器仪表资讯网(求)","host":"ht tp://www.1718china.com"},{"id":846614,"sitename":"勤加缘网" ,"host":"http://www.qjy168.com"}

    the data in table :

    仪器仪表资讯�?�?

    i selected 65001 (UTF-8) and the json file os utf-8 too
    how can i do

  • #2
    We would like your assistance to identify the problem. Please provide information as follows:

    1. Which version of Navicat are you using? e.g. Navicat for MySQL (Windows) 64-bit version 11.0.16.
    2. The source import file. Sample data will be fine as long as it reproduces the same problem.
    3. The sql file of the table (If you are importing to the existing table). You can control-click/right-click the database/table and choose Dump SQL File.
    4. Do you mean choosing the 65001 (UTF-8) in Encoding option in the Connection Properties?

    Comment

    Working...
    X