pythonのSQLiteでUTF-8を使う
pythonのsqlite3は標準でTEXTがunicodeを要求するようです。何も考えずにUTF-8を投げたらエラーを食らいました。 sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings. SQLiteでUTF-8を用いたい場合はtext_factoryにstrを指定して解決しました。 import sqlite3 db = sqlite3.connect("
Writing blob from SQLite to file using Python
A clueless Python newbie needs help. I muddled through creating a simple script that inserts a binary file into a blog field in a SQLite database: import sqlite3 conn = sqlite3.connect('database.db') cursor = conn.cursor() input_note = raw_input(_(u'Note: ')) input_type = 'A' input_file = raw_input(_(u'Enter path to file: ')) with open(input_file, 'rb') as f: ablob = f.read() f.close() cursor.exec
Advanced SQLite with Python: Storing and retrieving Blob and DateTime
Advanced SQLite with Python: Blob, Date, Time, etc. Introduction As usual, these notes are primarily for myself. I just collected in one place the excerpt from available documentation. I also used the information I found on the internet. Some links are presented in the Reference section. Storing and retrieving BLOBs Import of DB, os, image import sqlite3 import os.path from os import listdir, getc
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
