Arne asked 10 years ago
Hi!
It work just fine so far. But when I read from my SQL Server field containing our national character like Ø, the field is not showing in the grid.
I think I need to set something to Norway language, but how/what/where?
Abu Ghufran answered 10 years ago
I checked that there was utf8 fix required for mssql.
Emailing you build
Thanks
Arne answered 10 years ago
Superb – thank you!
I am very impressed – both with the quality of the product and the help and support I get from you.
🙂
Arne answered 10 years ago
sorry, not quite ok…
If I write data with these special character (ÆØÅ) through your grid, the data is stored in mssql with some bad characters.
The read is ok.
Can you fix this as well?
muuucho answered 10 years ago
Arne do you start the script with
<html lang="no">
<head>
<meta charset="utf-8">
The grid works for my swedish caracters ÅÄÖ
muuucho answered 10 years ago
Woops, but not in this Support forum.
Abu, could you make the Captha function a little more readable? Thanks.
Arne answered 10 years ago
no, I was wrong.
It did not work for me!
🙁
The data is not written correctly to the database if I use the special Norwegian character ÆØÅ.
After the fix from Abu, I can read correctly, but not write….
Any other suggestion?
muuucho answered 10 years ago
I found out that its not written correctly in my database either. It appears correctly when I display table contents through my scripts however.
Arne answered 10 years ago
Hi, sorry to say that it is not perfect still…
If I use dropdown to get a list from a table, and the list contains ÆØÅ the list will not show.
I use this syntax
$str = $g->get_dropdown_values("select distinct anleggId as k, anleggNavn as v from [datafangst].[dbo].[anlegg]");
$col["editoptions"] = array("value"=>$str);
and the field anleggNavn contains ÆØÅ. If I delete all the records containing these character, it works fine…
Can you fix this as well?
Arne answered 10 years ago
Hi again!
this works fine, but still there are something missing regarding translate of special Norwegian language characters:
I cannot search after words containing ÆØÅ.
And cells with ÆØÅ are not included in the export to Excel.
Are there any solution of this too?
Abu Ghufran answered 10 years ago
Hello Arne,
This ticket somehow got delayed too much.
I'll be updating you after working on it.
Apologies for the delay.
Abu Ghufran answered 10 years ago
Emailing you an update.
UTF8 encoding of text was required for tcpdf.
