Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: utf-8 problems kettle transformation mysql

  1. #1
    Join Date
    Nov 2011
    Posts
    4

    Default utf-8 problems kettle transformation mysql

    Hello everyone,
    this is my first post i have a problem using kettle with a database in mysql, im using the version 4.2.0 stable, and using this parameters into the options in the connection
    defaulFecthSize 500
    zeroDateTimeBahavior convertToNull
    clientEncoding utf8
    useCursorFecth true
    characterEncoding utf8

    but when i see the fields this are shown with uknow characters and is the same thing when I export to a csv file or connect to a postgres database

    could you give me a hand please

    Thanks a lot

    Greetings
    Paul A.

  2. #2
    Join Date
    Feb 2008
    Posts
    107

    Default

    Can you be a bit clearer as to what the problem is ? A screenshot could be useful too.

  3. #3
    Join Date
    Nov 2011
    Posts
    4

    Default

    Hello thanks dor the quickly answer this is the error
    Name:  errorkettle.jpg
Views: 398
Size:  39.5 KB

  4. #4
    Join Date
    Jun 2007
    Posts
    260

    Default

    On you db connection, try setting the initial database command to 'set names utf8'

  5. #5
    Join Date
    Nov 2011
    Posts
    4

    Default

    Did you say in the connection pool something like this:
    |parameter | value|
    -------------------
    |set names |utf8 |
    -------------------

  6. #6
    Join Date
    Nov 2011
    Posts
    4

    Default

    Because i have this parameters into my.cnf
    symbolic-links=0default-character-set=utf8
    init-connect='SET NAMES utf8'
    character-set-server=utf8
    collation-server=utf8_unicode_ci

    but even why this the characters are showing with errors

    Thanks a lot

    Greetings

    Paul Alarcon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.