Trouble reading special norwegian characters from MS SQLserver

QuestionsTrouble reading special norwegian characters from MS SQLserver
Arne asked 11 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?

18 Answers
Abu Ghufran answered 11 years ago

I checked that there was utf8 fix required for mssql.
Emailing you build

Thanks

Arne answered 11 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 11 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 11 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 11 years ago

Woops, but not in this Support forum.

Abu, could you make the Captha function a little more readable? Thanks.

Arne answered 11 years ago

Thank you Muuucho!
🙂

Arne answered 11 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 11 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.

Abu Ghufran answered 11 years ago

Hi Arne,

Just sent you another update.
Please override.

Thanks

Arne answered 11 years ago

Perfect!
Thank you!

muuucho answered 11 years ago

Abu, would you be so kind and send one for me as well?

Abu Ghufran answered 11 years ago

Emailed.

muuucho answered 11 years ago

Great, thanks!

Arne answered 11 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?

Abu Ghufran answered 11 years ago

Fix emailed. Issue was to utf_encode that data for mssql case.

Arne answered 11 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 11 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 11 years ago

Emailing you an update.
UTF8 encoding of text was required for tcpdf.

Your Answer

9 + 20 =

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?