postgres convert_from(X, 'UTF8') equivalent in PHP

Question

I have a SQL statement where a make a conversion with "convert_from(X, 'UTF8')" on a 'bytea'-field in PostgreSQL. I want to make the conversion not in SQL but in PHP. Is there an equivalent function for doing this in PHP?

deceze · Accepted Answer · 2012-02-10 12:19:56Z

1

iconv('UTF-8', $targetCharset, $x)

or

mb_convert_encoding($x, $targetCharset, 'UTF-8')

http://php.net/manual/en/function.iconv.php
http://php.net/mb_convert_encoding

You will have to specify the target character set, which is implied by the database encoding in the Postgres function.

answered Feb 10, 2012 at 12:19

deceze♦

525k89 gold badges806 silver badges954 bronze badges

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

1 Comment

deceze Over a year ago

Well, what is your end goal? What do you want to convert to?

user1027167 · Accepted Answer · 2012-02-10 15:00:37Z

0

the problem was that postgresql returns the field hex-coded. My solution in PHP now looks like this:

$str = pack('H*', str_replace('\x', '', $obj->BinData));

With this it is possible to retrieve text of a bytea-field.

answered Feb 10, 2012 at 15:00

user1027167

4,5088 gold badges36 silver badges42 bronze badges

Collectives™ on Stack Overflow

postgres convert_from(X, 'UTF8') equivalent in PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related