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