string conversion from utf8 - General topics, questions and discussions - Jabaco - Community

Community

Tutorials

Documentation

You are not logged in.

Beginner

Date of registration: Feb 25th 2009

Location: Beverungen / Weser

Occupation: Softwareentwicklung

Tuesday, February 1st 2011, 10:15am

string conversion from utf8

Hi all,

i have some german "Umlaute" in a mySQL database in UTF8 format.
How can I show the correct characters in my jabaco frontend textfield?

regards
Hubertus

Go to the top of the page

Intermediate

Date of registration: Jan 1st 2009

Location: Hanover, Germany

Occupation: Software Engineer

Hobbies: Hilbert Curves

Tuesday, February 1st 2011, 11:32am

As far as I know, all Java strings are composed of two-byte Unicode characters.
To resolve your problem, you should find out where the information gets lost or disturbed.
Is it between mySQL server and local application recordset?
Or is the data transfered correctly but garbled up when it comes to the TextBox?

Do you get two characters for one Umlaut character?

Greetings

A1880

Go to the top of the page

Beginner

Date of registration: Feb 25th 2009

Location: Beverungen / Weser

Occupation: Softwareentwicklung

Tuesday, February 1st 2011, 1:03pm

Thanks A1880,

I have just realized that the browser might be the cause for showing garbage.
My Webapplikation with PHP running in a CMS seems to be responsible.
I'm coming back with a solution or a cry for help.

regards
Hubertus

Go to the top of the page

Intermediate

Date of registration: Nov 19th 2009

Location: GERMANY

Tuesday, February 1st 2011, 1:47pm

Vielleicht hilft Dir dies weiter (maybe this helps):

http://forum.mysqldumper.de/die-umlautpr…-tun-t2313.html

latest Jabaco.jar:
Jabaco.jar on bitbucket since other links are down !!
Jabaco Framework source:
https://code.google.com/p/jabacoframework/source/list

Go to the top of the page

Beginner

Date of registration: Feb 25th 2009

Location: Beverungen / Weser

Occupation: Softwareentwicklung

Tuesday, February 1st 2011, 4:29pm

thanks Dani,

that was it. I just altered the characterset of the CMS from UTF-8 to Latin.
No garbage anymore.

regards
Hubertus

Go to the top of the page

Similar threads

- Suggestions »
- Translate Jabaco into your native language (Nov 25th 2008, 3:53am)
- Tips, Tricks, Samples & Tutorials »
- Access to Excel from Jabaco via JExcel (Feb 3rd 2009, 4:49pm)
- Suggestions »
- Automatic CStr() conversion of byte variables (Jul 28th 2009, 3:52pm)
- Visual Basic 6 Compatibility »
- Len for Variables (Jul 27th 2009, 1:19pm)
- General topics, questions and discussions »
- Very Large Conversion (Apr 7th 2009, 10:02am)

WoltLab Burning Board