# ACTIVE SCAFFOLD UTF-8 question/problem?

**URL:** <https://www.ruby-forum.com/t/active-scaffold-utf-8-question-problem/113384>\
**Category:** Rails\
**Created:** [August 30, 2007, 3:49pm UTC](https://www.ruby-forum.com/t/active-scaffold-utf-8-question-problem/113384 "2007-08-30T15:49:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![demoversion](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/4491bb/32.png) [@demoversion](https://www.ruby-forum.com/u/demoversion)\
**Post date:** [August 30, 2007, 3:49pm UTC](https://www.ruby-forum.com/t/active-scaffold-utf-8-question-problem/113384/1 "2007-08-30T15:49:16Z")

</div>

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 ☹  
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

---

<div class="post-metadata">

**Author:** ![demoversion](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/4491bb/32.png) [@demoversion](https://www.ruby-forum.com/u/demoversion)\
**Post date:** [August 30, 2007, 4:43pm UTC](https://www.ruby-forum.com/t/active-scaffold-utf-8-question-problem/113384/2 "2007-08-30T16:43:50Z")

</div>

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