Just don’t know what to do: any advice appreciated:
My DB is InnoDB utf-8 and I have no problems when I get information from
db, displaying it in the broswer or saving it.
Except one case:
I’m saving the text with umlaut. This works fine if my browser’s
character encoding is set to utf-8.
But: if I switch encoding to western ( ISO-8859-1 ), then copy the
string with umlaut to the field, and click on save I get the following
Mysql::Error: #22001Data too long for column ‘_text’ at row 1: UPDATE
creation_time = ‘2006-10-04 21:17:23’,
= ‘Stefan Haï¿½’, <…>
The POST request is sent with Content-Type:
So it looks like it sents request in western encoding.
POST Content differes for the case when I have browser encoding set to
utf8 and when it is set to western.
It could be quite OK if I hadn’t that error. BTW, I don’t have this
error under linux, only under windows (probably because under linux ruby
version is 1.8.4 and under windows 1.8.5?)
I tried everything I found about unicode, I tried to find the way to
escape string before saving it, but no success((
Any ideas, please?