Euro symbol and other characters distorted
Euro symbol and other characters distorted
- Subject: Euro symbol and other characters distorted
- From: David Griffith <email@hidden>
- Date: Tue, 13 Jun 2006 15:15:23 +0200
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:
This email sent to email@hidden