Storing encrypted data?
От | John Tregea |
---|---|
Тема | Storing encrypted data? |
Дата | |
Msg-id | 44BAE3B0.8060403@debraneys.com обсуждение исходный текст |
Ответ на | Re: hi i need to connect database from my system to another ("Penchalaiah P." <penchalaiahp@infics.com>) |
Ответы |
Re: Storing encrypted data?
|
Список | pgsql-sql |
Hi, <br /><br /> Does anyone have experience with storing encrypted data into pgSQL? I have a pgSQL database which usesUTF8 encoding. I am encrypting plain text in my (GUI) application and sending it to a field (with data type 'text') inmy database. <br /><br /> I get an error back saying "invalid byte sequence for encoding UTF8; oxd733"<br /><br /> I amusing blowfish at 128bit to encrypt the string.<br /><br /> The encrypted string comes out looking like this<br /><br /><fontface="Arial" size="-1">Salted__ë±9r™LZPÃOG¤u–¨ékTz~6Ëpi™|O +Lϰ‹r°ô9•mµ�á%€©õP{:‚Àªd<br /> îX@ûñÙÁl£ðŒ…¢53P9×ð“á6kUÆ¢÷ÍìMNÉA•—ä![ˆj”Ø|¨\X–ÛÜu�ªÅÜ-ÎáBæºñȦbF >\Žv/ÞÎ.&ó«[=bný�Kr°óË2U×ZI©âVc°sn=¤Õg«^q0Ã8ý<Êh�;”¨"�[Šç+u[£ –è—=‘±ú3³�ì¯,Za@LU‘T¸œÖgœËPÛ<…H—8ÃbÙÉŽNÙí>ÇL]í¶²–âŒÿ/Ínz¶å<br/> Õ?Îcµˆ$í¿W-™óà¢ey÷àÞ¬œ¤CðÏjX”ÃGÄ„·º?ë0L‘هƞ‹&ˆ{ªìëá/Ç}k9?ÄX1⋲T½Hõ5Ôgÿ§yÈy…_—ú$lA~©î1úëùññðÑÝŠžgÕþÊ/«¦…8�¯þ >ü‚ƒ€–aÈÉ„iG‰}¹²#À</font><br/><br /> I enclose that in single quotes and send it in an insert statement to pgSQL. <br/><br /> The statement has been working, until I got to a string that generated the above encrypted data, then it broke.<br/><br /> Alternatively, can anyone suggest an encryption algorithm that will only return characters that are validUTF8 encoded?<br /><br /> Thanks in advance<br /><br /> John T<br /><br /><br />
В списке pgsql-sql по дате отправления: