Sample Header Ad - 728x90

Getting truncated content from Apple Notes SQLite DB

0 votes
0 answers
49 views
If you run this query on your Mac OS, it prints latest note from Notes app. The issue that there is more content, it gets truncated. I have numbers from 1 to 300, but only 1 to 82 are returned. What is the issue? How to print complete content? Thanks
% cd "$HOME/Library/Group Containers/group.com.apple.notes" && \\
sqlite3 NoteStore.sqlite "SELECT * FROM ZICCLOUDSYNCINGOBJECT ORDER BY Z_PK DESC LIMIT 1"
4882|11|12|0|0|0|0|0|0|||4874|||||||||||||||||||||||||||||||||||||||0|0|0|0|0|||0||4|3|2593||||||||||||||||||||||||||||||||||||||||||758832855.156849|758832855.158181|758228055.158249|758228055.158249|758832855.158247||758834369.024801|-541228980||758835621.195935|||||2D21D111-B939-430E-95BC-55BA145654E6||||||||||||||||||||||||||||||||||1||notes-length-test|notes-length-test
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82||||||||||||||||||||

||||||||||||||||||||||||||
%
Note
Asked by laimison (131 rep)
Jan 17, 2025, 07:50 PM
Last activity: Jan 17, 2025, 08:38 PM