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 '[EMAIL PROTECTED]' 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 PROTECTED]
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/david%
40infinityspain.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/the_larsons%
40mac.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
