I doubt that indexing has anything to do with it whatsoever.
Of course it does. ORDER BY, LIKE, TRIM, and other SQL expressions
that
do more than an equal comparison need to know the actual data
representation. If you were to convert to UTF-8 or UCS-2 in the Python
program and
On 10/20/07, John Nagle [EMAIL PROTECTED] wrote:
Gert-Jan wrote:
sophie_newbie schreef:
Hi, I want to store python text strings that characters like é Č
in a mysql varchar text field. Now my problem is that mysql does not
seem to accept these characters. I'm wondering if there is any way
Diez B. Roggisch wrote:
No, no, that's wrong. MySQL and the Python interface to it understand
Unicode. You don't want to convert data to UTF-8 before putting it in a
database; the database indexing won't work.
I doubt that indexing has anything to do with it whatsoever.
Of course
Hi, I want to store python text strings that characters like é Č
in a mysql varchar text field. Now my problem is that mysql does not
seem to accept these characters. I'm wondering if there is any way I
can somehow encode these characters to appear as normal characters
and then decode them when I
On Oct 20, 2:13 pm, sophie_newbie [EMAIL PROTECTED] wrote:
Hi, I want to store python text strings that characters like é Č
in a mysql varchar text field. Now my problem is that mysql does not
seem to accept these characters. I'm wondering if there is any way I
can somehow encode these
sophie_newbie schreef:
Hi, I want to store python text strings that characters like é Č
in a mysql varchar text field. Now my problem is that mysql does not
seem to accept these characters. I'm wondering if there is any way I
can somehow encode these characters to appear as normal characters
Gert-Jan wrote:
sophie_newbie schreef:
Hi, I want to store python text strings that characters like é Č
in a mysql varchar text field. Now my problem is that mysql does not
seem to accept these characters. I'm wondering if there is any way I
can somehow encode these characters to appear as
No, no, that's wrong. MySQL and the Python interface to it understand
Unicode. You don't want to convert data to UTF-8 before putting it in a
database; the database indexing won't work.
I doubt that indexing has anything to do with it whatsoever.
Here's how to do it right.