search for: collation

Hello, I am struggling with what seems a common unresolved problem, changing the password from voicemailman when using a realtime engine (adaptive_odbc in my case, connected to mysql). I have seen messages dating back to 2007 with this problem and the last one was bug 5168, reported as closed, but without explaining the fix

Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

Hello. Voice quality when calling - this is one of the most important in the PBX. You need to record the quality parameters for each call to improve. Because the overall quality of a call can only be determined upon completion, I did it in the HangUp handler and wrote in custom fields of CDR. This worked well in asterisk 11. In asterisk 13 I did not find a handler after the call, but before

For sometime now I have not been able to print Collated pages on windows client machines Domain Wide. Our print server is cups, running on Linux Gentoo. If I print directly to the printer within windows I am able to collate. If a Linux machine prints from command line specifying Collate=True while printing pages it works. I have been searching quite some time now to find a fix, or a how to but no

...ass(Class = "A", representation = representation(B = "B", C = "C")) setClass(Class = "B", representation = representation(C = "C")) setClass(Class = "C", representation = representation(something = "character")) Obviously, the collation for sourcing these defs needs to be: C, B, A. Which doesn't correspond to the default collation of R (alphabetically). I've tried to pick up on how to ensure the right collation when building R Packages by reading some previous posts and as far as I understand I've basically got two op...

-----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of jg Sent: Monday, July 06, 2015 4:14 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR in an MySQL-Database > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database.

Hi! I have ran on problem with collations. In database.yml I have set: encoding: utf8, but when in console run: >> ActiveRecord::Base.connection.collation => "latin1_swedish_ci" It is Rails 2.1, mysql gem 2.7, mysql 5.1.22. This leads to errors like: Mysql::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT)...

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=>&qu...

> Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database. > I created the DB and a user for Asterisk on a separate server, then I > configured my cdr_mysql.conf so: > > [global] > hostname=192.168.10.3 > dbname=asterisk > table=cdr > password=MYSECRET > user=asterisk > port=3306 > > and my cdr.conf so: > >

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

[crossposted to -stable and -i18n, replies directed to -stable] Hi everyone, could someone point me to infos regarding Unicode collation support in FreeBSD? All I could find was https://wiki.freebsd.org/KonradJankowski/Collation but that page has not been changed in more than two years. Looking at sources of -current it doesn't look like those changes made it into the source tree yet. Wolfgang

because of problems you are facing i decided to go way with second table CREATE TABLE `cdr_extended` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `uniqueid` varchar(32) NOT NULL DEFAULT '', `callid` varchar(256) NOT NULL DEFAULT '' COMMENT 'sip call-id', `hangupcause` varchar(10) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL COMMENT 'info about

Luca Bertoncello wrote: > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database. > I created the DB and a user for Asterisk on a separate server, then I > configured my cdr_mysql.conf so: > > [global] > hostname=192.168.10.3 > dbname=asterisk > table=cdr > password=MYSECRET > user=asterisk > port=3306 > > and my

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

One issue left for me to figure out is that in different languages there are different characters and Xapian takes only english characters. Thefore many word entered by users that contains their own language special characters will not return any result. MySQL offers different collations ... Now when I see how much data Xapian can search perhaps I could expand my index spider different European countries but how will I deal with different collation, interesting question. Kevin http://nitra.net -------------- next part -------------- An HTML attachment was scrubbed... URL: http:...

Hello, I am having this mysql error in my ruby on rails application. ActiveRecord::StatementInvalid occurred in > event#lg: > Mysql::Error: Illegal mix of collations > (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for > operation ''='': select * from locations where country = ''HU'' and > geo_state = ''08'' and city = ''Pázmánd'' and zip = ''(null)'' and lat...

...rather with platform. >>>> >>>> I wonder if you?ve seen this. If it?s not some setting I?m unaware of, >>>> maybe someone should look into it. Sorry I haven?t taken the time to read >>>> the source code myself. >>> >>> Looks like a collation order issue. See ?Comparison. >> >> With the oddity that both platforms use what look like similar locales: >> >> LC_COLLATE=en_US.UTF-8 >> LC_COLLATE=en_US.utf8 > > It's the sort of thing thay I've tried to wrap my mind around multiple times and failed,...

...to specify all ASCII letters is to list them all as the character class ?[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz]?." This is from POSIX specification: "In the POSIX locale, a range expression represents the set of collating elements that fall between two elements in the collation sequence, inclusive. In other locales, a range expression has unspecified behavior: strictly conforming applications shall not rely on whether the range expression is valid, or on the set of collating elements matched. A range expression shall be expressed as the starting point and the ending...

The following caused a hard-to-diagnose problem for a user of the survey package. Presumably this is a strange Unicode thing, but is there a convenient reference for how the collation order is determined? I am surprised that adding the same character to the end of two strings of the same length can change the sorting order. in en_US.utf8 locale > "1//"<"10/" [1] TRUE > "1//2"<"10/2" [1] FALSE in C locale on the same system....

On 2/23/15 3:03 AM, Yaron Nachum wrote: > 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 >