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 17:00:10 +0200
HI Xavier,
Sorry I see what you mean about the email, I'll start a fresh one in
the future to avoid problems..
I'm talking about types in mySQL. I am using mySQL 4.1.19 with
connector-j 3.0.17. Having read on the list (and the problem with
BLOBs returning hex instead of text) I reverted to using 3.0.17 from
3.1.7. I cannot get any 3.1.x connector-j to work correctly with BLOBs.
I have tried converting the BLOB columns in mySQL to TEXT and
MEDIUMTEXT but it truncates so much that it destroys the data. I
can't figure any other reasonable way of converting them. If I can
convert them to TEXT columns in mySQL successfully, that will be a
start. However I am now getting the Euro symbol (which is in a
VARCHAR) displaying as rubbish as well where that used to be fine
before. I think that has only happened since I added the UTF8 code
(application and session) and changed the header in the HTML pages to
force UTF8.
It's a real nightmare.. I was actually in the process of trying to
convert the whole thing over to FrontBase as I just cannot figure out
what to do about this. The problem is the conversion to Frontbase
will take a while too with all the referenital integrity stuff so I
have to be careful and I don't want to lose any data either.
Kind regards,
David.
On 13 Jun 2006, at 16:52, Dev WO wrote:
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.
You probably first did "reply" to the post about "Handi Wikibook
link" the change the subject. But all the references about the
"previous" email where still in the mail header so that's why it's
in the same thread (when messages are sorted by thread).
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?
Are you talking about types in EOModeler or types in your database?
Which version of MySQL are you using? 4.1.x?
I had the same issue, I just have to recall what I did...I'll
search the list to see if I recall something.
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?
TEXT is already 65535 characters long (I think MySQL 4.1.x handles
in number of characters) so it's not the issue.
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