Problem with MS SQL DB charset CP1250

QuestionsProblem with MS SQL DB charset CP1250
Pavel asked 10 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 10 years ago

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

Pavel answered 10 years ago

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

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

Abu Ghufran answered 10 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 10 years ago

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

Thanks

Pavel

Abu Ghufran answered 10 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 10 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 10 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

5 + 19 =

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?