ACTIVE SCAFFOLD UTF-8 question/problem?

Rails
1

Hi all,

Who can help me with problem?

I’m using active scaffold for managing my models, but i get a problem
with standart search when i’m looking for
records that saved in UTF-8 in database.

For example:
I have some models:

name=“igor”
name=“john”
name=“ivan”
name=“вася”
name=“анна”

in search field i type symbol = “а”(russian) and i get no results :frowning:
when i typed symbol “i”(english) i get 2 models - “igor” and “ivan”

This i get at console log(for symbol ‘а’(in russian):
SELECT * FROM ogoloshenyatypes WHERE ((LOWER(ogoloshenyatypes.name)
LIKE ‘%Р°%’)) LIMIT 0, 15

And “а” — symbol ‘а’(russian) in database

What to do?

ps:

html page charset - utf-8
database charset - utf-8

ps2:
another example — autocomple for UTF-8 work’s

Thank you for reply

2

Igor K. wrote:

Hi all,

Who can help me with problem?

I’m using active scaffold for managing my models, but i get a problem
with standart search when i’m looking for
records that saved in UTF-8 in database.

html page charset - utf-8
database charset - utf-8

ps2:
another example — autocomple for UTF-8 work’s

Thank you for reply

!!!
yes i found!!!

who need a solution for this problem -
please change CHARACTERSET to utf8_unicode_ci, before i used utf8_bin