decodeURIComponent for postgres

Question

I use decodeURIComponent and encodeURIComponent in Javascript. Before I store this data in a UTF-8-PostgreSQL-Database, I should decode them:

$my_data = pg_escape_string(utf8_encode($_POST['my_data']));

I'm looking for a PostgreSQL-Function to convert Javascript-Encoded Data.

This is as useful as storing binaries in the DB as base64-encoded TEXT instead of using BYTEA. Probably sometimes it has is uses but generally? Are you sure you need to do this? — Milen A. Radev
– Milen A. Radev, Commented Sep 17, 2009 at 14:49
milen, storing base64 is likely to reduce bandwidth required for storage/retrieval ;-) — Michael Krelin - hacker
– Michael Krelin - hacker, Commented Sep 18, 2009 at 6:47

Community · Accepted Answer · 2017-05-23 12:01:22Z

2

You're not making yourself too clear, but maybe this will be of interest for you.

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Sep 17, 2009 at 13:06

Michael Krelin - hacker

144k25 gold badges200 silver badges177 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

maletin Over a year ago

Thank you, but I'm missing a more complex function: w3schools.com/jsref/jsref_encodeURI.asp

Michael Krelin - hacker Over a year ago

Well, there's no encodeURI function in postgresql. Maybe, there's one available as module. But I doubt you really need it. What are you trying to achieve?

Collectives™ on Stack Overflow

decodeURIComponent for postgres

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related