similar to: dump and import MySQL table w/ accents

Hi all, I am trying to configure utf8 in mysql under centos6 to display special characters, like accents. I use this mysql instance to store plain syslog logs. I have configured this under my.cnf: [mysqld] init_connect = 'SET collation_connection = utf8_general_ci' init_connect = 'SET NAMES utf8' character-set-server = utf8 collation-server = utf8_general_ci [client]

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) and (utf8_general_ci,COERCIBLE) for operation

I am running into problems with MySQL and lookups. The table has character set utf8, but: mysql> select id, token from tokens where token = ''esta''; +-------+-------+ | id | token | +-------+-------+ | 83417 | está | +-------+-------+ 1 row in set (0.00 sec) How do I configure things so MySQL doesn''t ignore accents? TIA, Jeffrey

Hello. I want to write my notes in Sweave in my own language (spanish). But my language has accents and when I run Sweave in R to translate my Snw file into the tex file the accents are translated into unrecognizable characters. For example, the word "cami?n" (truck) is translated into "cami??n" Somebody knows how can I do it? One solution I don't like is using a

Hi, How can I include accents and signs like '?' '?' in the plots generated by R? I try, but R automatically transforms the name ex: > countries <- c("M?xico", "Espa?a") > countries [1] "M\216?xico" "Espa\216?a" > I've seen in some Spanish texts about R how is it normal to include labels of the plots and other names with

Hi, I've a problem with the accents. How do I configure Xapian to ignore the accents in the search/indexes? Thanks, Nuno Mariz

Hi, I am using libxapian in a C++ project (hence I am using Xapian's C++ API) and some user has requested that search requests should ignore accents. E.g. when the user searches for "Herr Müller" he expects that "Herr Muller" is also a search hit. Is this possible in Xapian? Do you have any links to the documentation of that feature? Thanks for your help, Kim

Hello Could someone please direct me to the correct commands for adding accents (grave and aigu) to a letter in a plot title, label, or in added text? I'm sure there's a handy list somewhere, but I've failed in coming up with the correct search words to find it. Thank you muchly! Jen

I have an openoffice spreadsheet with a column of character strings. Some of them contain accents. I want to read it in R so I have saved it as a csv file using Western Europe (ISO-8859-1) character set (the default, I've tried other sets but it doesn't help). R reads it fine with CharMatrix<-read.csv("test.csv",header=F,sep=",",as.is=TRUE); Say I wan't to

Hi, I was searching archives, manuals and web to solve usage of fonts with accents in R, but I was not succesfull. Had anybody solve problem with usage of fonts with accents (czech)? Thanks for advice, Jakub Zlamal -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send

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

Hello, I have a problem with special characters such as "?" or "?" when using hwriter. This only happens when I use windows, it works fine on mac. If I do: print(datosdv) "Ciencias Sociales y Jur?dicas n:74 | 33.94%" but: hwrite(datosdv, p, br=TRUE) "Ciencias Sociales y Jur?dicas n:74 | 33.94%" The bad sign is in the code, is not a problem of the

Hello, I have build a syntax to find out if a given substring is included in a larger string that works like this: d1$V1[regexpr("some text = 9",d1$V2)>0] <- 9 and this works all right till "some text" contains standard ASCII set. However, it does not work when accents are included as the following: d1$V1[regexpr("some t?xt = 9",d1$V2)>0] <- 9 I have

Hello, my application controller defines before_filter :set_charset def set_charset @headers["Content-Type"] = "text/html; charset=ISO-8859-1" end Everything is fine and accents are rendered correctly in the browser. However, when I call a controller/action from Ajax (Prototype), the charset is not taken in account and accents are garbage displayed (''?''

Dear all, there is a R function to remove all accents in strings? best regards. JL [[alternative HTML version deleted]]

Anyone know, under Linux, how to get accents (hoping for u with an umlaut, for example) into a comment field? They're happily in the comment file I'm using as a source (or on the command line), but they get translated into # either when I do vorbiscomment -a or vorbiscomment -l (not sure which, but XMMS also sees # instead of the right char, which implies the first). title=Die Sch#ne

Hi all, I have a samba install that is coring dump every time a file with accents on the file name is accessed. Do any one knows how to work around this? I'm using samba version 4. Please let me know if you guys need any more info regarding my install. Thanks in advance. Leon

Hello, I''m having troubles with accents in words I retrieve from database. What I expect is ''Retención'' but what I get is ''Retenci?n''. When I retrieve that info with a Java app it works fine. Is there any solution? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups

Hello, I wrote a RoR app on OSX and SQL Server. The DB uses SQL_Latin1, so I use Iconv to convert to UNICODE every dynamic text I show on the pages (Iconv.conv(''utf-8'', ''iso-8859-1'', string)). That''s been working fine until I deployed the app on a debian box. Since then, the accents are shown as question marks, and I don''t know why. The

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