decode double slash octal

Поиск
Список
Период
Сортировка
От Weiss, Jörg
Тема decode double slash octal
Дата
Msg-id 4B4E89127868BD458A795430BCF4FD1328DAB263@DVZSN-RA0325.bk.dvz-mv.net
обсуждение исходный текст
Список pgsql-sql
<div class="WordSection1"><p class="MsoNormal"><span
style="font-family:"Arial","sans-serif";mso-bidi-font-family:"TimesNew Roman"">Hi!</span><p class="MsoNormal"><span
style="font-family:"Arial","sans-serif";mso-bidi-font-family:"TimesNew Roman""> </span><p class="MsoNormal"><span
lang="EN-US"style="font-family:"Arial","sans-serif";mso-bidi-font-family:"Times New Roman";mso-ansi-language:EN-US">I
use<span class="SpellE">pgcrypto</span> <span class="SpellE">encrypt_iv</span> and <span class="SpellE">
decrypt_iv</span>to crypt and <span class="SpellE">decrapt</span> data. The data is stored in an <span
class="SpellE">bytea</span>field.</span><p class="MsoNormal"><span lang="EN-US"
style="font-family:"Arial","sans-serif";mso-bidi-font-family:"TimesNew Roman";mso-ansi-language:EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US" style="font-family:"Arial","sans-serif";mso-bidi-font-family:"Times New
Roman";mso-ansi-language:EN-US">Toencrypt I use this SQL for example: <span style="mso-spacerun:yes"> </span><span
class="SpellE">encrypt_iv</span>(‘<spanclass="SpellE">Bärbel</span>’, '<span class="SpellE">MyPassword</span>',
decode('<spanclass="SpellE">Tn5Tuxy7x9NWBybEcUvKBQ</span>==', '<span class="SpellE">base64</span>'), '<span
class="SpellE">aes</span>')</span><pclass="MsoNormal"><span lang="EN-US"
style="font-family:"Arial","sans-serif";mso-bidi-font-family:"TimesNew Roman";mso-ansi-language:EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US" style="font-family:"Arial","sans-serif";mso-bidi-font-family:"Times New
Roman";mso-ansi-language:EN-US">Todecrypt I use this SQL: encode(<span class="SpellE">decrypt_iv</span>(<span
class="SpellE">nachname</span>,<span class="SpellE">MyPassword</span> ', decode(iv, '<span
class="SpellE">base64</span>'),'<span class="SpellE">aes</span>'), 'escape')</span><p class="MsoNormal"><span
lang="EN-US"style="font-family:"Arial","sans-serif";mso-bidi-font-family:"Times New
Roman";mso-ansi-language:EN-US"> </span><pclass="MsoNormal"><span lang="EN-US"
style="font-family:"Arial","sans-serif";mso-bidi-font-family:"TimesNew Roman";mso-ansi-language:EN-US">When I decrypt
thefield <span class="SpellE">nachname</span> in PostgreSQL 8.1 it returns the correct <span class="SpellE">
german</span>word “<span class="SpellE">Bärbel</span>”.</span><p class="MsoNormal"><span lang="EN-US"
style="font-family:"Arial","sans-serif";mso-bidi-font-family:"TimesNew Roman";mso-ansi-language:EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US" style="font-family:"Arial","sans-serif";mso-bidi-font-family:"Times New
Roman";mso-ansi-language:EN-US">WhenI do it the same way in PostgreSQL 9.3 I got this “B\\303\\<span
class="SpellE">244rbel</span>”.The <span class="SpellE">geman</span> <span class="SpellE">UTF</span>-8 letters are
escaped,octal-encoded letters.</span><p class="MsoNormal"><span lang="EN-US"
style="font-family:"Arial","sans-serif";mso-bidi-font-family:"TimesNew Roman";mso-ansi-language:EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US" style="font-family:"Arial","sans-serif";mso-bidi-font-family:"Times New
Roman";mso-ansi-language:EN-US">Howcan I decode “B\\303\\<span class="SpellE">244rbel</span>” to “<span
class="SpellE">Bärbel</span>”?I find no solution for this problem.</span><p class="MsoNormal"><span lang="EN-US"
style="font-family:"Arial","sans-serif";mso-bidi-font-family:"TimesNew Roman";mso-ansi-language:EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US" style="font-family:"Arial","sans-serif";mso-bidi-font-family:"Times New
Roman";mso-ansi-language:EN-US">Regards</span></div>

В списке pgsql-sql по дате отправления:

Предыдущее
От: Xavier Stevens
Дата:
Сообщение: Re: [GENERAL] encrypt psql password in unix script
Следующее
От: Weiss, Jörg
Дата:
Сообщение: Octal to UTF-8