CodeIgniter-PostgreSql编码错误
|
我正在将PostgreSQL与CodeIgniter结合使用，并且在使此查询正常工作时遇到一些问题。错误如下：
A Database Error Occurred
Error Number:
ERROR: invalid byte sequence for encoding \"UTF8\": 0x8a HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by \"client_encoding\".
select * from table
where
lower(translate(country_ad, \'()!$?: ,&+-/.ŠŒŽšœžŸ¥µÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýÿ\' , \'-------------SOZsozYYuAAAAAAACEEEEIIIIDNOOOOOOUUUUYsaaaaaaaceeeeiiiionoooooouuuuyy\')) = lower(\'Portugal\')
and
lower(translate(zone_ad, \'()!$?: ,&+-/.ŠŒŽšœžŸ¥µÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýÿ\' , \'-------------SOZsozYYuAAAAAAACEEEEIIIIDNOOOOOOUUUUYsaaaaaaaceeeeiiiionoooooouuuuyy\')) = lower(\'Lisboa\')
Filename: C:\\xampp\\htdocs\\pesquisa\\system\\database\\DB_driver.php
Line Number: 330
没有找到相关结果
已邀请:
1 个回复
擅香