Data truncated for column 'text' at row 1

Hi!
I have built my site on the Django dev server and everything
works
fine there. But when I uploaded the project to a Apache +
mod_python
server I got an error

Data truncated for column 'text' at row 1

That is shown when I pass swedish chars like å ä and ö into
a form,
which then POST's the form back to the same page.  The whole
warning-
message reads:

Warning at /
Data truncated for column 'text' at row 1
Request Method: 	POST
Request URL: 	http://sql.bidclub.se/
Exception Type: 	Warning
Exception Value: 	Data truncated for column 'text' at row 1
Exception Location:
	/usr/lib/python2.4/site-packages/MySQLdb/
cursors.py in _warning_check, line 80
Python Executable: 	/usr/bin/python
Python Version: 	2.4.4

The POSTing works 'cause when I return to the site I can see
the post.
I guess this has something to do with unicode or something,
but I
don't really know where to look.

Any hint is really appreciated!

Thanks in advance


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at htt
p://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---

 SD> Data truncated for column 'text' at row 1

[...]

 SD> The POSTing works 'cause when I return to the site I
can see the post.
 SD> I guess this has something to do with unicode or
something, but I
 SD> don't really know where to look.

 SD> Any hint is really appreciated!

This means exactly what's written there: data was truncated.
 Check how
long 'text' column is and, probably, alter table to increase
its size.

-- 
Andrey V Khavryuchenko            
Django NewGate -  http://www.kds.com.ua/
djiggit/
Development - http://www.kds.com.ua 
Call akhavr1975 on www.gizmoproject.com

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at htt
p://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---

I had the same problem, caused by using the letters å, ä and
ö, when
editing my database from the admin page.
For me it was solved by recreating the database with
character set
utf8 and collation utf8_unicode_ci.
I use MySql 5.0.37 and Django 0.96.

http://dev.mysql.com/doc/refman/4.1/en/charset-genera
l.html

I hope it helps. Ester Ytterbrink


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at htt
p://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---