FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » store backslash in mysql database
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: store backslash in mysql database [message #170665 is a reply to message #170652] Sun, 14 November 2010 16:14 Go to previous messageGo to previous message
Michael Fesser is currently offline  Michael Fesser
Messages: 215
Registered: September 2010
Karma:
Senior Member
.oO(Robert Hairgrove)

> I suggest you convert the data to something like base64 format or URI
> encoding before storing it in the database. That way, you avoid this
> issue and perhaps a few others as well (i.e. any unforeseen implicit
> conversions of binary data). Besides, you can store the data as a normal
> VARCHAR or TEXT field.

I would rather suggest to find the real reason for the problem and fix
it. It's a bug in some part of the code, not in MySQL.

If MySQL would have a problem with such data, you won't be able to store
BLOBs either. But a byte can be anything from 0x00..0xFF. Binary data is
binary data - MySQL won't touch it, so the problem is somewhere in the
scripts. Either the decryption fails or - even more likely - the data is
already improperly sent to the DB by the encryption script.

Micha
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: website url as input how to create and save image on server in php?
Next Topic: Cannot write utf8 data into a utf8 column
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 11:04:15 GMT 2024

Total time taken to generate the page: 0.04648 seconds