close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

new server / characters in database code

Thread began 7/14/2020 11:58 am by Patrice | Last modified 7/14/2020 7:46 pm by Ray Borduin | 47 views | 7 replies |

Patrice

new server / characters in database code

I migrated to a new server and some old sites that were fine are now showing the "diamond with question mark for apostrophes" or missing spaces. Digging through old issues, I found where line 137 in ck editor 5 had a line replacement. Checking a site that is throwing the errors, I see that site was using that correction. (http://www.webassist.com/forums/posts.php?id=37452)

The database is set to latin / swedish character sets, same as old server.

On page meta is <meta charset=UTF-8>. Seeing another thread I tried a uni-code replacement but it didn't affect anything.

An example page that is throwing errors: https://professional-siding.com/siding.php which was ok on old server. It's an older site so created before I was using the new mysqli, so it is using the original database interface.

Any ideas what to change on new server to correct? Or why a new server would cause this issue?

Thanks

Sign in to reply to this post

Ray BorduinWebAssist

Usually the database, connection, and page should be using the same charset setting to make sure they show characters correctly. You may just need to update your connection and specify the charset as utf8 there.

If you access the database directly with phpmyadmin do the characters show correctly there? The issue could have occurred with the transfer to the new server.

Sign in to reply to this post
Did this help? Tips are appreciated...

Patrice

Looking directly to db,

It�s

<meta charset=UTF-8>

Sign in to reply to this post

Ray BorduinWebAssist

So it looks correct when viewing with phpmyadmin?

You could try adding this to the bottom of the connection:

mysql_set_charset('utf8',$prof);
Sign in to reply to this post
Did this help? Tips are appreciated...

Patrice

no... in the database it is reflecting

�

instead of an apostrophe.

I will add

mysql_set_charset('utf8',$prof);

to the prof.php in the connection folder

Sign in to reply to this post

Patrice

Adding that in removed the diamond and replaced with the characters

Sign in to reply to this post

Patrice

There are only 6 sites affected so I'm just going to go change the curly apostrophes to straight. I will test a new page on server this week to see if it is still happening or it was an issue with migration.

Sign in to reply to this post

Patrice

I have manually fixed all 6 sites that needed help.

Next week, I will start a new site and see if new server has issues ... I suspect migration was the problem but I will see.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...