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 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 a workaround for this (and
not converting
to a BLOB
is not an option... sorry
What version of mysql are you using?
Version 4.1.12
What character set is the TEXT column?
latin1_swedish_ci
What are you using to display this text?
PHP / HTML
Although my guess is that the characters are not lost, it's just
that the software is now just getting binary (blob) data back
and doesn't know how to decode it.
If you convert the field back to TEXT can you see the
chars again?
Yes i do...
Looks like the PHP will need to explicitly decode the data from mysql
as latin1_swedish_ci before display. I don't know PHP but maybe
someone else round here knows how...
Are you sure you want to store text in a blob, seems to be
making life hard for yourself?
mark
--
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 going to have a chat
with my boss...
Thanks for the help, and i will post a solution i find back on here
Mike
--
Medusa, Media Usage Advice B.V.
Science Park Eindhoven 5216
5692 EG SON
tel: 040-24 57 024
fax: 040-29 63 567
url: www.medusa.nl
mail: [EMAIL PROTECTED]
Uw bedrijf voor Multimedia op Maat
