Re: Character Set Problems
Re: Character Set Problems
- Subject: Re: Character Set Problems
- From: David Griffith <email@hidden>
- Date: Thu, 15 Jun 2006 17:29:21 +0200
Hi John,
Thanks, it's good to know that. I have finally managed to solve this
one, by hours and hours of messing with different collations and
character sets. Finally I have found a way to convert the old BLOBs
to TEXT fields in the database and things seem to have finally
returned to normal.
Thanks to all who replied,
Regards,
David
On 15 Jun 2006, at 15:34, John Larson wrote:
David - check this out:
MySQL Bugs: #18321: Can't store Euro Sign with latin1_german1_ci
and latin1_general_ci
http://bugs.mysql.com/bug.php?id=18321
Hope it helps.
I tried "select '\342\202\254' as a;" and had mysql spit out a euro
sign. If I try to store it in a table, it puts a ? in there.
(David - about as frustrating as figuring out why my iterator isn't
iterating)
John
On Jun 15, 2006, at 8:19 AM, David Griffith wrote:
Have finally discovered that the mySQL server was upgraded from
version 4.0.24 to version 4.1.19.
We were using Connector/J version 3.1.7. Have reverted to 3.0.17
so that instead of seeing '[b@djhfjd' we now see the proper text,
but the encoding is wrong or at least any special characters
appear as '?'.
The original columns were BLOBs. I have tried to convert them to
TEXT but with no success.
Does anyone know what I can do, or am I going to have to re enter
all this data?
Kind regards,
David.
On 15 Jun 2006, at 13:57, David Griffith wrote:
Ok people,
At this stage I am willing to pay anyone that is prepared to
spend some time with me on this. I'm pulling my hair out and
going around in circles. Please, anyone that can help, mail me
directly on email@hidden.
See previous messages on Problems with euro symbol and character
sets..
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:
40infinityspain.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:
40mac.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