Eclipse Community Forums: BIRT

Home » Archived » BIRT » encoding problem(problem with retrieving correct data from latin2 db table)

Sun, 26 September 2010 12:35

Eclipse User

Hello,
I have a problem. DB tables in project are set to latin2 (ISO8859_2) encoding. I was trying to create Data Source in my report with jdbc, and I always get wrong chars. It is MySQL Datbase.

connection string:
jdbc:mysql://localhost/db?characterEncoding=ISO8859_2

even if I use other encodings I get the same Sad

. I realy need some help, I've stuck on it for few days.

Re: encoding problem [message #629362 is a reply to message #629038]

Mon, 27 September 2010 19:48

Eclipse User

Janusz

Can you open a bugzilla entry for this?

Jason

On 9/26/2010 12:35 PM, Janusz Paszynski wrote:
> Hello,
> I have a problem. DB tables in project are set to latin2 (ISO8859_2)
> encoding. I was trying to create Data Source in my report with jdbc, and
> I always get wrong chars. It is MySQL Datbase.
>
> connection string:
> jdbc:mysql://localhost/db?characterEncoding=ISO8859_2
>
> even if I use other encodings I get the same :(. I realy need some help,
> I've stuck on it for few days.

Re: encoding problem [message #630013 is a reply to message #629038]

Thu, 30 September 2010 07:37

Eclipse User

I wasn't sure if it is bug, and in which project (Birt MySQL JDBC Connector).

I did made few more test and with url:
jdbc:mysql://localhost/db?characterEncoding=ISO8859_2&re sultsEncoding=ISO8859_2

I get all strings in different encoding than previously. I don't get proper chars (like ą, ć, ł) but '?' mostly. I think it is a problem with MySQL. Especially when I tried to check different encodings with simple Java Application with JDBC. In that case I always get '?' char instead of i.e. 'ą' or 'ł'.

Previous Topic:	Embeding Generated reports to other web page
Next Topic:	reset pagenumber on group without interval

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 02:21:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter