search for: utf8_unicode_ci

Displaying 10 results from an estimated 10 matches for "utf8_unicode_ci".

2015 Jan 20
1
Mailbox password change problem on realtime engine
...increment. I checked the mysql log and no attempt is made to change the password. Any idea about the source of the problem? This is my voicemail table: CREATE TABLE IF NOT EXISTS `voicemail` ( `uniqueid` int(11) NOT NULL AUTO_INCREMENT, `te_id` int(11) NOT NULL, `context` char(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default', `mailbox` char(80) COLLATE utf8_unicode_ci NOT NULL, `password` char(80) COLLATE utf8_unicode_ci NOT NULL, `fullname` char(80) COLLATE utf8_unicode_ci DEFAULT NULL, `email` char(80) COLLATE utf8_unicode_ci DEFAULT NULL, `pager` char(80) COLLATE utf8_uni...
2015 Feb 23
2
Dynamic Music on Hold
Hello everyone, I am trying to activate Music On Hold using DB on Asterisk 13. It works fine but in order to use new Music On hold definitions I have to reload the moh module. - The following is my configuration in extconfig.conf - I added the following line: musiconhold.conf => mysql,asterisk,bit_ast_config - The following is the table in the database: mysql> select * from
2015 Feb 23
0
Dynamic Music on Hold
...me database all changes will take effect immediately. The following link explains the difference between realtime and static: https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration Here is the structure I use: CREATE TABLE `musiconhold` ( `name` varchar(80) COLLATE utf8_unicode_ci NOT NULL, `directory` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `application` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `mode` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `digit` char(1) COLLATE utf8_unicode_ci NOT NUL...
2009 Sep 08
2
Realtime static with Asterisk 1.6.1.6
...the same table structure since 1.4.x. CREATE TABLE `ast_config` ( `id` int(11) NOT NULL auto_increment, `cat_metric` int(11) NOT NULL default '0', `var_metric` int(11) NOT NULL default '0', `commented` int(11) NOT NULL default '0', `filename` varchar(128) collate utf8_unicode_ci NOT NULL, `category` varchar(128) collate utf8_unicode_ci NOT NULL default 'default', `var_name` varchar(128) collate utf8_unicode_ci NOT NULL, `var_val` varchar(200) collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `filename_comment` (`filename`,`commented`) ) ENGINE=My...
2013 Jun 12
0
Best way to set database connection collation in rails?
Hello, I want to change the connection collation that rails uses but I''m unsure of exactly what the best way to do this is. Everything in MySQL - the server, database and all tables are set to utf8_unicode_ci collation, but the connection collation in rails still appears to be utf8_general_ci (the default?). We are using the mysql2 adapter. I''ve seen a couple of possible methods: Set the collation to utf8_unicode_ci via an init-connect line in the database server''s my.cnf Set the...
2009 Oct 08
1
Realtime static does not work in 1.6.1 or 1.6.2
...int(11) NOT NULL default '0', `filename` varchar(128) NOT NULL, `category` varchar(128) NOT NULL, `var_name` varchar(128) NOT NULL, `var_val` varchar(200) NOT NULL, PRIMARY KEY (`id`), KEY `filename_comment` (`filename`,`commented`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; What changed since 1.6.1.X to break realtime static? I do not see any errors on startup, the dialplan simply does not load. Since we have developed our own GUI for configuration we cannot use it with these versions of Asterisk. -- Telecomunicaciones Abiertas de M?xico S.A. de C.V. Carlos Ch...
2006 Aug 10
1
Customizing log output
I''d like to include the user name along with/instead of the session id in my log files. Is there a place to customize the log format, or do I just need to through the logger object and manually write it in a before_filter on my ApplicationController? Thanks. -- Jack Christensen jackc@hylesanderson.edu
2007 Aug 30
1
ACTIVE SCAFFOLD UTF-8 question/problem??
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 =
2010 Sep 15
1
csv/Rails 3/ruby 1.9.2p0/mysql encoding problem
...] Now, I''m reading that string in using: require ''csv'' CSV.foreach(fname, :encoding => ''u'') do |row| Then I''m just storing that string using the standard ActiveRecord method. In mysql, when I do "show table status;", I get "utf8_unicode_ci" as the encoding for all the tables. When I try to display that data in a browser, however, I get a 500 error with the message: "incompatible character encodings: ASCII-8BIT and UTF-8" In the header of my page, I see: Content-Type text/html; charset=UTF-8 I don''t know w...
2010 Feb 23
1
Rails on Snow Leopard
...ot;utf8", "username"=>"root", "adapter"=>"mysql", "database"=>"app_development", "pool"=>5, "password"=>nil, "socket"=>"/var/run/mysqld/mysqld.sock"}, charset: utf8, collation: utf8_unicode_ci (if you set the charset manually, make sure you have a matching collation) or if you run rake db:migrate and see an error like this: rake aborted! Can''t connect to local MySQL server through socket ''/var/run/mysqld/ mysqld.sock'' (38) The problem is that the mysqld.sock...