Accent problem

QuestionsAccent problem
Jean-Yves Blanchette asked 11 months ago

We would like to buy your grid. We are currently testing and we are seeing a problem. If a grid has fields that contain accented characters, the grid's features stop working.
If there are no accents everything works perfectly

define("PHPGRID_DBTYPE","odbc_mssql"); // mysql,oci8(for oracle),mssql,postgres,sybase
define("PHPGRID_DBHOST","Driver={SQL Server};Server=sql-xxxxx.xxx.xxxxsqlinfo2008r2;Database=SupportInfo;CharacterSet=utf-8");
define("PHPGRID_DBUSER","xxxxxxx");
define("PHPGRID_DBPASS","xxxxxxxx");
define("PHPGRID_DBNAME","SupportInfo");

Thank you

3 Answers
Abu Ghufran answered 11 months ago

If you mean ascent character in field names, then it is not supported.
If you mean ascents in field data, then we have tested it with mssqlnative driver.

You can try mssqlnative OR pdo.

$db_conf = array();
$db_conf["type"] = "mssqlnative"; // or mssql
$db_conf["server"] = "(local)sqlexpress"; // ip:port
$db_conf["user"] = null;
$db_conf["password"] = null;
$db_conf["database"] = "master";

OR

$db_conf = array();
$db_conf["type"] = "pdo";
$db_conf["server"] = "sqlsrv:Server=(local)sqlexpress";
$db_conf["user"] = null; // username
$db_conf["password"] = null; // password
$db_conf["database"] = "master"; // database

Jean Beaudet answered 11 months ago

Thank you

I dont have accent in my field name, only in field data

I use this parameter :

define("PHPGRID_DBTYPE","odbc_mssql");
define("PHPGRID_DBHOST","Driver={SQL Server};Server=sql-info2.csbf.localsqlinfo2008r2;Database=SupportInfo;CharacterSet=utf-8");
define("PHPGRID_DBUSER","support");
define("PHPGRID_DBPASS","xxxxxxxxxx");
define("PHPGRID_DBNAME","SupportInfo");

if i use this table no problem

2 CORE 2 DUO – T5500 / 1.66 GHZ 901
9 CORE 2 DUO – E8400 @ 3.00GHZ 2044
17 CORE 2 E7400 2.80GHZ 1864
18 CORE I5 CPU [email protected] 204 GHZ 2387
20 CORE 2 T6500 2100 MHZ 1457
21 DUAL CORE T4200 2.0G 800MHZ 1222
22 CORE 2 DUO – E7500 @ 2.93GHZ 1979
23 SEMPRON 3100+ 158

But if I add an accent “é” I obtain an ERROR

2 éééééCORE 2 DUO – T5500 / 1.66 GHZ 901
9 CORE 2 DUO – E8400 @ 3.00GHZ 2044
17 CORE 2 E7400 2.80GHZ 1864
18 CORE I5 CPU [email protected] 204 GHZ 2387
20 CORE 2 T6500 2100 MHZ 1457
21 DUAL CORE T4200 2.0G 800MHZ 1222
22 CORE 2 DUO – E7500 @ 2.93GHZ 1979
23 SEMPRON 3100+ 158

I have try

define("PHPGRID_DBTYPE","mssqlnative"); // mysql,oci8(for oracle),mssql,postgres,sybase
define("PHPGRID_DBHOST","sql-info2.csbf.localsqlinfo2008r2");
define("PHPGRID_DBUSER","support");
define("PHPGRID_DBPASS","xxxxxxxx");
define("PHPGRID_DBNAME","SupportInfo");

I obtains this message : Couldn't execute query. SQLState: IMSSP Error Code: -14 Message: An invalid parameter was passed to sqlsrv_query. – select top (1+0) * FROM Puissance WHERE 1=1

Thank you for helping

Jean-Yves

Your Answer

4 + 11 =

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!