Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > php通过odbc用sql语句查询时无法查询中文，应该怎么转码？

php通过odbc用sql语句查询时无法查询中文，应该怎么转码？

WBOY
Release： 2016-06-02 11:34:56
Original
1741 people have browsed it

phpsql乱码informix

数据库是informix，编码是iso-8859-1，php编码是gbk。从网上找了各种方式转换，都不行。
代码如下，其中$licenseno是车牌号，中间有省份缩写是汉字。

<code>$sql.="and b.licenseno = \"".$licenseno."\"";</code>
Copy after login

会返回错误如下：

<code>Warning: odbc_exec() [function.odbc-exec]: SQL error: [Informix][Informix ODBC Driver]Inexact character conversion during translation., SQL state S1000 in SQLExecDirect in D:\wamp\www\chaxun\chaxun.php on line 79</code>
Copy after login

请问应该怎么做？谢谢

Related labels：
php sql 乱码 informix
source：php.cn
Previous article：代码分析-哪位能给下面这段php代码写个详细分析，最好具体到每一行。 Next article：度数据库报错-用php逐条读取mysql中的数据报错为什么？？
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2158
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2309
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1946
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1820
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1874
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template