MS SQL DB special characters umlauts

QuestionsMS SQL DB special characters umlauts
Markus H. asked 7 years ago

Hi,
we have a problem to save special characters (german umlauts) in our database by the Grid.

Grid: äüö@€
DB: äüö@€

Could you help me please ?
Thanks
Best regards.
Markus

3 Answers
Abu Ghufran answered 7 years ago

Hello,

Please confirm if you are using mssqlnative php extension to connect sql server.
This extension supports utf8 and work smooth.

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

christian G. answered 5 years ago

hi, what if im not using nativemssql ? I use mssql and i cannot render data with non english characters. For example \”Ñ\”…. the render is not working in this cases.

Abu Ghufran Staff answered 5 years ago

Logging answer for others:

Try following:
Edit lib/inc/jqgrid_dist.php and Search+replace:

$responce->rows[] = $row;

With:

$responce->rows[] = array_utf8_encode_recursive($row);

It should do manual encode of each data array item, before sending to JS.

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Your Answer

16 + 7 =

Login with your Social Id:

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 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

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

Let us improve this post!

Tell us how we can improve this post?