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
>> 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
> progra
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
>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.
>
>
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 t
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 cha
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" th
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
