如何使用PHP和SQL在PostgreSQL中插入重音字符？

Question

Using PHP, the following string was generated

INSERT INTO persons ("username","firstname") VALUES ('nino','Niño')

but when tried to execute the statement at runtime like so:

<?php
...
$query = 'INSERT INTO persons ("username","firstname")'." VALUES ('nino','Niño')";
$result = $pgsql->query( $query );
?>

it was not inserted to the table, but when I issued the same statement in the phpPgAdmin, it was inserted.

Is there a working way to insert accented characters in PostreSQL using PHP & ezSQL?

Answer 1

Try this.

$data = 'Niño'
$escaped = pg_escape_string(utf8_encode($data));
$query  = "INSERT INTO correspondence (name, data) VALUES ('nino', '{$escaped}')"