Skip to content

gh-108590: Improve sqlite3 docs on encoding issues and how to handle those #108699

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
erlend-aasland merged 18 commits into from
Oct 25, 2023
Merged

gh-108590: Improve sqlite3 docs on encoding issues and how to handle those #108699

Changes from 1 commit
Commits
Show all changes
18 commits
Select commit Hold shift + click to select a range
139ad73
gh-108590: Add sqlite3 text factory howto
erlend-aasland Aug 30, 2023
88a7599
Apply suggestions from code review
erlend-aasland Aug 30, 2023
f9aac63
Add note to iterdump(); explain why we use CAST
erlend-aasland Aug 31, 2023
60aebce
Merge Alex's review
erlend-aasland Aug 31, 2023
1fead55
Pull in main
erlend-aasland Aug 31, 2023
fdc240f
Mention that execute() and friends only accept UTF-8 encoded strings
erlend-aasland Aug 31, 2023
62073e5
Try to emphasize that strings with surrogate escapes cannot be passed…
erlend-aasland Aug 31, 2023
35c6e9d
Add seealso for the Unicode HOWTO
erlend-aasland Aug 31, 2023
d136048
Pull in main
erlend-aasland Sep 1, 2023
3b9f620
Try to address reviews:
erlend-aasland Sep 4, 2023
6487fa6
Pull in main
erlend-aasland Sep 4, 2023
57f1a57
Fix note
erlend-aasland Sep 4, 2023
c4cbe84
Address review: don't need to show how to create the database
erlend-aasland Sep 4, 2023
9b78bf2
Remove execute*() changes
erlend-aasland Sep 4, 2023
a91fa7c
Update Doc/library/sqlite3.rst
erlend-aasland Sep 7, 2023
3411791
Update Doc/library/sqlite3.rst
erlend-aasland Sep 7, 2023
dc4c820
Apply suggestions from CAM and Ezio
erlend-aasland Oct 12, 2023
7e0e615
Keep it simple
erlend-aasland Oct 13, 2023
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Keep it simple 
Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
  • Loading branch information
@erlend-aasland @ezio-melotti
erlend-aasland and ezio-melotti authored Oct 13, 2023
commit 7e0e615f4533b54af6a2ed62f9b499f91632f1ff
6 changes: 2 additions & 4 deletions Doc/library/sqlite3.rst
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -2623,10 +2623,8 @@ you can use the following technique, borrowed from the :ref:`unicode-howto`:

.. note::

Strings containing surrogate escapes must be treated with care.
For example, you cannot pass them back to SQLite,
since the :mod:`!sqlite3` module API does not support strings
containing surrogate escape codes.
The :mod:`!sqlite3` module API does not support strings
containing surrogates.

.. seealso::

Expand Down