On 20 Jan 2012, at 19:41, Diogo FC Patrao wrote: > I was writing a huge text explaining those problems in mysql encoding in this > e-mail, but it would be very annoying to those who would not be interested; I > published it instead into my blog: > > http://goo.gl/Xju2b
Diogo, that's a very nice article. Bookmarked! I'm really looking forward to the day where everyone uses UTF-8 and we don't need to deal with this mess any more… Richard > > > -- > diogo patrão > > > > > > On Fri, Jan 20, 2012 at 2:35 PM, Richard Cyganiak <[email protected]> wrote: > As Diogo said, the client charset must be utf8 or D2R won't see the right > characters. > > I would have guessed that the connection string you're using would fix the > issue. One thing that *might* help is to have a look at the section > “Specifying JDBC connection properties” in the D2RQ manual and specify the > properties that way rather than in the connection string. > > A few other things to consider: > > - the strings might already have been broken when inserted into the database > - individual tables and columns can have a different encoding from the DB > defalt > - are you able to connect to the server with a GUI client (e.g., MySQL > workbench) and do the characters show correctly there? > > Best, > Richard > > > On 20 Jan 2012, at 15:51, Susanna Martinelli wrote: > > > Thanks for the quick reply. > > Mysql server has this configuration: > > > > Connection id: 318 > > Current database: siconart > > Current user: root@localhost > > SSL: Not in use > > Current pager: stdout > > Using outfile: '' > > Using delimiter: ; > > Server version: 5.0.51a-24+lenny5 (Debian) > > Protocol version: 10 > > Connection: Localhost via UNIX socket > > Server characterset: latin1 > > Db characterset: utf8 > > Client characterset: latin1 > > Conn. characterset: latin1 > > UNIX socket: /var/run/mysqld/mysqld.sock > > Uptime: 1 day 1 hour 42 min 32 sec > > > > Each table in the DB has Charset=utf8 > > I've tried to rewrite the connection string for D2RServer to: > > jdbc:mysql://localhost:3306/siconart?useUnicode=true&characterEncoding=utf8 > > However no success :( > > Maybe the Server charset is wrong? > > any Ideas? > > > > thanks in advance. > > Susanna > > > > > > On Fri, Jan 20, 2012 at 4:00 PM, Richard Cyganiak <[email protected]> > > wrote: > > Susanna, the charset is probably wrong in your database and you need to fix > > it there… > > > > Best, > > Richard > > > > > > On 20 Jan 2012, at 14:27, Susanna Martinelli wrote: > > > > > Hi, I have a problem with charset encoding into D2Rserver. > > > I need to change charset from "utf-8" to "latin1" because > > > rdfs:label into D2RServer browser writes wrong characters. > > > like this: > > > Come si può vedere dalle mappe di distribuzione degli elementi, il > > > calcio è > > > > > > Does anyone know which file(s) I need to change? > > > thanks > > > Susanna > > > ------------------------------------------------------------------------------ > > > Keep Your Developer Skills Current with LearnDevNow! > > > The most comprehensive online learning library for Microsoft developers > > > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > > > Metro Style Apps, more. Free future releases when you subscribe now! > > > http://p.sf.net/sfu/learndevnow-d2d_______________________________________________ > > > d2rq-map-devel mailing list > > > [email protected] > > > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel > > > > > > ------------------------------------------------------------------------------ > > Keep Your Developer Skills Current with LearnDevNow! > > The most comprehensive online learning library for Microsoft developers > > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > > Metro Style Apps, more. Free future releases when you subscribe now! > > http://p.sf.net/sfu/learndevnow-d2d_______________________________________________ > > d2rq-map-devel mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel > > > ------------------------------------------------------------------------------ > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > _______________________________________________ > d2rq-map-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel > ------------------------------------------------------------------------------ Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 _______________________________________________ d2rq-map-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
