Converting TEXT to BLOB with special chars

2006-07-18 Thread Mike van Hoof
Hello, I am having a problem, and am hoping this is the wright list to post to. I have a TEXT field with text in them (duh!)... this text also contains special characters like é ß ü etc... But when i convert the TEXT field to a BLOB field these signs are lost and i get � So does anyone know

RE: Converting TEXT to BLOB with special chars

2006-07-18 Thread Addison, Mark
From: Mike van Hoof Sent: 18 July 2006 10:49 Hello, I am having a problem, and am hoping this is the wright list to post to. I have a TEXT field with text in them (duh!)... this text also contains special characters like é ß ü etc... But when i convert the TEXT field to a BLOB

RE: Converting TEXT to BLOB with special chars

2006-07-18 Thread Addison, Mark
From: Mike van Hoof Sent: 18 July 2006 12:18 To: Addison, Mark Subject: Re: Converting TEXT to BLOB with special chars Addison, Mark schreef: From: Mike van Hoof Sent: 18 July 2006 10:49 Hello, I am having a problem, and am

Re: Converting TEXT to BLOB with special chars

2006-07-18 Thread Mike van Hoof
Addison, Mark schreef: From: Mike van Hoof Sent: 18 July 2006 12:18 To: Addison, Mark Subject: Re: Converting TEXT to BLOB with special chars Addison, Mark schreef: From: Mike van Hoof Sent: 18 July 2006 10:49 Hello, I am having

Re: Converting TEXT to BLOB with special chars

2006-07-18 Thread Chris Sansom
At 13:40 +0200 18/7/06, Mike van Hoof wrote: Well.. gonna try some text-converting in php then... And yeah, it really needs to be a blob field... not my choice, but we got a CMS which operates on field types from MySQL... and a blob field wil generate an WYSIWYG field... but i think i am

Re: Converting TEXT to BLOB with special chars

2006-07-18 Thread Mike van Hoof
Chris Sansom schreef: At 13:40 +0200 18/7/06, Mike van Hoof wrote: Well.. gonna try some text-converting in php then... And yeah, it really needs to be a blob field... not my choice, but we got a CMS which operates on field types from MySQL... and a blob field wil generate an WYSIWYG

Re: Converting TEXT to BLOB with special chars

2006-07-18 Thread Chris Sansom
At 14:16 +0200 18/7/06, Mike van Hoof wrote: And for the everything in utf8... will try this next time i get this kind of a problem... When you do, you'll need to send out the proper header from your php scripts: header ('Content-type: text/html; charset=UTF-8'); and put this in your MySQL