ronrsr wrote:
now, I can't do any string operations, I get the error msg:
descriptor 'lower' requires a 'str' object but received a 'unicode'
args = (descriptor 'lower' requires a 'str' object but received
a 'unicode',)
what's a string operation in this context? are you trying to
ronrsr wrote:
querystring = update zingers set keywords = '%s', citation =
'%s', quotation = %s' where zid = %d %
(keywords,citation,quotation,zid)
that's not a good way to pass strings to the database. for the right
way to do this, see:
ronrsr wrote:
Try putting use_unicode=True in the MySQLdb connect call.
tried that, and also added charset=utf8 -
now, I can't do any string operations, I get the error msg:
descriptor 'lower' requires a 'str' object but received a 'unicode'
args = (descriptor 'lower'
I have an MySQL database called zingers. The structure is:
zid - integer, key, autoincrement
keyword - varchar
citation - text
quotation - text
the encoding and collation is utf-8
I am having trouble storing text, as typed in last two fields. Special
characters and punctuation
ronrsr wrote:
I have an MySQL database called zingers. The structure is:
zid - integer, key, autoincrement
keyword - varchar
citation - text
quotation - text
the encoding and collation is utf-8
I am having trouble storing text, as typed in last two fields. Special
structure for the DB:
CREATE TABLE `zingers` (
`zid` int(9) unsigned NOT NULL auto_increment,
`keywords` varchar(255) default NULL,
`citation` text,
`quotation` text,
PRIMARY KEY (`zid`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 AUTO_INCREMENT=422 ;
code for
are you passing in the strings as Unicode strings, or as something else?
if you're using something else, what have you done to tell the
database what it is?
not at all sure what I'm passing it as.
The database default encoding is utf-8
the database collation is utf-8
the page encoding
ronrsr wrote:
are you passing in the strings as Unicode strings, or as something else?
if you're using something else, what have you done to tell the
database what it is?
not at all sure what I'm passing it as.
The database default encoding is utf-8
the database collation is utf-8
version of python is 2.2 -
--
http://mail.python.org/mailman/listinfo/python-list
version of python is either 2.2 or 2.4
bests,
-rsr-
John Nagle wrote:
ronrsr wrote:
--
http://mail.python.org/mailman/listinfo/python-list
ronrsr wrote:
code for storing to database:
querystring = update zingers set keywords = '%s', citation =
'%s', quotation = %s' where zid = %d %
(keywords,citation,quotation,zid)
You're missing a single quote in there around the quotation %s.
Are you also replacing \\ with r\\
Try putting use_unicode=True in the MySQLdb connect call.
tried that, and also added charset=utf8 -
now, I can't do any string operations, I get the error msg:
descriptor 'lower' requires a 'str' object but received a 'unicode'
args = (descriptor 'lower' requires a 'str' object
12 matches
Mail list logo