Jump to content
Sign in to follow this  
ShadowMage

Server sent charset unknown

Recommended Posts

I'm trying to configure a new web server to migrate the company intranet, but I'm getting the following error:

Server sent charset (255) unknown to the client. Please, report to the developers

I did a little googling and it is supposedly a PHP bug that was fixed in version 7.0-ish.  I am running MySQL 8.0.15 with PHP 7.3.3 (on Win Server 2019, if that matters) and still getting this error.  I tried setting the character_set_server to 'UTF8MB4' but that didn't seem to do anything.

Please help.

Share this post


Link to post
Share on other sites

It sounds like you need to set the character set to utf8 in MySQL.

Share this post


Link to post
Share on other sites

I did that, I think.  That's what I meant by setting the character_set_server.  I launched the MySQL command line and ran the following:

set global character_set_server = 'UTF8MB4';

It gave me a warning if I set it to just 'UTF8'.  Something about being ambiguous with UTF8MB3?

Should I be setting this somewhere else?

Share this post


Link to post
Share on other sites

UTF8MB4 is what PHP doesn't understand.  That isn't going to work.  When I searched for that error message I saw people saying they fixed it by changing to regular utf8.

Share this post


Link to post
Share on other sites

Thanks, got it all figured out.

 

Share this post


Link to post
Share on other sites

Got a new problem now.  I'm trying to connect to a Progress DB using OpenEdge 10.2A and getting this error:

The specified DSN contains an architecture mismatch between the Driver and Application

Clearly its complaining about the fact that I'm running 64-bit PHP and trying to use a 32-bit driver (that's the only driver available).  I've enabled 32-bit applications in the app pool on IIS but it's still giving this error.  Any ideas?

Share this post


Link to post
Share on other sites

The Progress DB?  Yes, I believe so.  I have no trouble connecting to it with the same driver on the current intranet (which is running 32-bit PHP 5.??)

Share this post


Link to post
Share on other sites

Are you connecting via ODBC?

It sounds like they don't exactly keep their stuff up to date:

A common PHP configuration in Windows environments uses IIS 5.1, PHP 5.1, and Microsoft SQL Server 2005.

Share this post


Link to post
Share on other sites

Yes, via ODBC.  I set up the DSN in the 32-bit data source manager and a test connection succeeds there.  Am I going to have to downgrade PHP and MySQL to 32-bit?

Share this post


Link to post
Share on other sites

If you're required to use Progress, it looks like you may need to use an older version of PHP.  I would contact them and try to find out what their plans are for support.  If it's difficult to get in touch, I wouldn't use them.

Share this post


Link to post
Share on other sites

Unfortunately, i am required to use Progress...  I am in touch with Epicor to try to get drivers, otherwise I will revert PHP to an older version.  Luckily, Epicor 10 (which we are planning to upgrade to this fall) has moved away from Progress and adopted MySQL so I won't have to deal with this anymore after that. :)

Thanks for your help!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...