Problem with MS SQL DB charset CP1250

QuestionsProblem with MS SQL DB charset CP1250
Pavel asked 5 years ago

Hi,
I have problem with prezentation any special character from code page CP 1250.
I'm using UTF-8 in html pages, but DB (MS SQL) is in CP1250.
Most of 'Czech' chacaters is OK, but any is not show, show other character.
I have
" <meta content="text/html; charset=UTF-8" http-equiv="Content-Type" />"
in top of page with
"<script src="./phpgrid/lib/js/jqgrid/js/i18n/grid.locale-cs.js" type="text/javascript"></script>"

Could you help me please ?
Thanks

7 Answers
Abu Ghufran answered 5 years ago

Please send me some test data (characters) which are not showing.
I'll recheck it on mssql and utf8 option.

Pavel answered 5 years ago

Hi,
this is original test string "žščřě ňůúýáí"

and this is in prezenteation žš"èøì òùúýáí".

Abu Ghufran answered 5 years ago

Hello,

I am still working to find some resolution for your issue.
Unsuccessful till now, i'll update you once ready.

Pavel answered 5 years ago

Hi,
do you have any new info about this problem ?

Thanks

Pavel

Abu Ghufran answered 5 years ago

Hi,

Since your last message, i am working on this case as top priority.
I'll be updating you once some result is achieved.

I have come to a point, that the JSON format b/w js grid and php lib must be in UTF8 format.
And in encoding/decoding the json, the utf8_decode is removing certain characters.
I am still trying some alternates to resolve this and find a better utf8 encode/decode function.

Pavel answered 5 years ago

I'm sorry,
but now is big problem for me and my app, because I need to run this app in production enviroment and users cannot see right names and they not use filtering field about this item 🙁

Pavel

Abu Ghufran answered 5 years ago

Update for others:

Ticket is resolved via emailing a mssql-patch for utf8.
Also, after the patch, customer feedback was:
We install new server WIN 2012 and new MSSQL client and now grid is OK 🙂

Your Answer

14 + 6 =

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:

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

Let us improve this post!