Re: Euro symbol and other characters distorted
Re: Euro symbol and other characters distorted
- Subject: Re: Euro symbol and other characters distorted
- From: Dev WO <email@hidden>
- Date: Tue, 13 Jun 2006 16:54:13 +0200
3.2.0beta on the server (deployment)
and either 3.0.17 or 3.20beta on the development machines: mysql-
connector-java-3.0.17-ga-bin.jar
By the way, which version of Connector/J are you using?
David.
On 13 Jun 2006, at 16:01, Dev WO wrote:
Hello David,
so first of all, you should start a new email when asking a new
question, if you don't, thread don't work correctly:)
I had the same issue as you when moving from MySQL 4.0.x to 4.1.x.
The solution was to change all the BLOB to mediumtext (or
longtext, but medium is already bigger than what you'd really
want), apply a caracter encoding to those fields (which should be
UTF-8).
Then make sure you don't have any specific encoding in your
connection dictionary (or UTF-8).
Make sure your web page header and the "head" declaration of your
pages is also UTF-8
And finally you should be OK.
If you have Practical WO at hand, there's a couple method to add
in the Application.java and in the Session.java to make sure
everything is UTF-8 (it's in the chapter about localization).
I'm sure it was already posted on this list, maybe search for UTF-8.
You should be going before the end of the day:)
Xavier
HI all,
I have a database (using mySQL) with a number of BLOB fields that
store long text values. Apparently BLOBs have no character
encoding so I presume this is applied at the time it is retrieved
from the database.
Previously everything was working fine but now I am getting all
sorts of strange behaviour. For example the Euro symbol (which
is stored in a field which is of type VARCHAR) is not displaying
correctly - have a look at http://www.ipodshoppers.com if you
want to see what I mean.
All the data from the BLOB fields are displaying ? instead of
certain symbols and I cannot figure out what to do. I have spent
about 3 days already trying to figure it out. I really need some
help here as I am unable to update any of the data.
I appears that the data is read from the BLOB, is not interpreted
correctly and displays wrong, then when I try to write back to
the database it can't update because of the ? in the text, which
do not exist in the BLOB.
It's an absolute nightmare. I have tried applying UTF-8 encoding
everywhere I can but it makes no difference at all. I even tried
converting the BLOBs to TEXT fields but that only served to
truncate 90% of the fields and lose most of the data.
Does anyone have any idea what I can do?
Kind regards,
David.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40anazys.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden