Jump to content

Resolved - Moving CC v5 site - SQLite encoding


Recommended Posts

I've successfully moved our test v5 store from a managed web hosting server to an unmanaged VPS, in an effort to get v5 running quicker (so for so good on this score).

 

My current issue is character encoding, which manifests in GBP symbols and other special characters displaying incorrectly.

 

Checking phpinfo() for the managed host (which works correctly) and the VPS, the line I suspect is relevant is:

 

- Managed host - SQLite > SQLite Encoding > UTF-8

 

 

- VPS - SQLite > SQLite Encoding > iso8859

 

 

I'm guessing I need to change the encoding on the VPS, but can't seem to find any way to do it. Can it be done with the php ini file?

 

Russell

 

 

 

Link to comment
Share on other sites

**Issue resolved**

 

It was much more straight forward than I thought, and nothing to do with SQLite encoding, ini.php files, etc.

 

Going into: Admin > Dashboard > Settings > Currencies, the 'Symbol Left' for GBP had somehow become corrupted in the move and was displaying as a '?' in a black diamond. Replacing this with the correct '£' GBP symbol has instantly solved the issue.

 

Russell

Link to comment
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.

×
×
  • Create New...