Re: [d2rq-dev] Charset encoding

[Richard C. <ri...@cy...>]

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 <ri...@cy...> 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 <ri...@cy...> 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
> > > d2r...@li...
> > > 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
> > d2r...@li...
> > 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
> d2r...@li...
> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
>