search for: utf8_bin

...tdown=yes [mysql] usegmtime=no loguniqueid=yes loguserfield=yes accountlogs=yes I created the table in the DB so: CREATE TABLE IF NOT EXISTS `cdr` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', `src` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', `dst` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', `dcontext` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', `lastapp` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '...

...s > loguserfield=yes > accountlogs=yes > > I created the table in the DB so: > > CREATE TABLE IF NOT EXISTS `cdr` ( > `id` int(11) unsigned NOT NULL AUTO_INCREMENT, > `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', > `clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `src` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `dst` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `dcontext` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `lastapp` varchar(200) COLLATE utf8_bin N...

...s > loguserfield=yes > accountlogs=yes > > I created the table in the DB so: > > CREATE TABLE IF NOT EXISTS `cdr` ( > `id` int(11) unsigned NOT NULL AUTO_INCREMENT, > `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', > `clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `src` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `dst` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `dcontext` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `lastapp` varchar(200) COLLATE utf8_bin N...

...s > loguserfield=yes > accountlogs=yes > > I created the table in the DB so: > > CREATE TABLE IF NOT EXISTS `cdr` ( > `id` int(11) unsigned NOT NULL AUTO_INCREMENT, > `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', > `clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `src` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `dst` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `dcontext` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `lastapp` varchar(200) COLLATE utf8_bin N...

hello: I have built a project with Instant Rails.Now only a database and a scaffold based on a product model have finished.But when i inputted "../admin/list" in my browser,i found my chinese characters cound not display normally.Then i made five steps: 1 ajusting encoding in my browser menu 2 in "C:\InstantRails\conf_files\my.ini"directory,making sure

Any thoughts on how to avoid this problem? Already tried: 1. Setting the charset and collation in migration 001 - no effect: def self.up db_name = ActiveRecord::Base::connection.current_database() execute "ALTER DATABASE #{db_name} CHARACTER SET utf8 COLLATE utf8_bin" end 2. Setting the charset and collation on each table individually - no effect: {:options=>"engine=InnoDB CHARACTER SET utf8 COLLATE utf8_bin"} Note that development and production environments work fine with database default, migration 001, or setting per each table. Onl...

I am switching to a composite primary key (string and user ID) from the Rails conventional auto-incrementing integer primary ID. The table is large (2.5 million records) and I''d rather not discard the contents. The composite_primary_key gem doesn''t appear to support altering the table with a migration to do its magic, only creating a table from scratch. So I dumped the table

If you use ActiveRecord::Base.connection.create_database you''ll notice that by default the created db will use latin1 encoding. I created a plugin to handle different charset and collations (on top of helping you with other boring DB tasks). You can check out the early version of the plugin svn checkout svn://rubyforge.org/var/svn/raketasks/db_tasks (I really need to move my projects out

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 =