• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Character Set Problems
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
References: 
 >Character Set Problems (From: David Griffith <email@hidden>)
 >Re: Character Set Problems (From: David Griffith <email@hidden>)
 >Re: Character Set Problems (From: John Larson <email@hidden>)

  • Prev by Date: Re: Problem with webobject attributes in WOBuilder
  • Next by Date: Re: Euro symbol and other characters distorted
  • Previous by thread: Re: Character Set Problems
  • Next by thread: How to include a Framework in a WebObjects Application
  • Index(es):
    • Date
    • Thread