Re: Euro symbol and other characters distorted
Re: Euro symbol and other characters distorted
- Subject: Re: Euro symbol and other characters distorted
- From: David Griffith <email@hidden>
- Date: Tue, 13 Jun 2006 16:33:39 +0200
Hi Xavier,
Thank you for your reply. I'm not sure what you meant about starting
a new email, I thought I did, but anyway I'll bear that in mind.
The problem is that I tried to convert the columns from BLOB to TEXT
already but it truncated virtually every field. Can you tell me how
you did it?
I've done virtually everything else you've said below and no
difference at all, hence the reason I want to switch to TEXT fields.
I used TEXT rather than MEDIUMTEXT but TEXT should be long enough,
should it not?
Kind regards,
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