Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

? mark has replaced £ sign.


scottydog72

Recommended Posts

Hi all,

 

I've copied a data base to a new domain using phpmyadmin, it worked well apart from the (£) pound sign being replaced by a (?) question mark.

It hasn't happened with other currencies.

 

Any advice please..

 

Scotty.

Link to comment
Share on other sites

You need to set the default character set in mysql before you export if it hasn't already been set. If you don't do this your file will not be in any character set and the unusual characters will not be decoded on import into the new database.

 

If you read the mysql forums there appears to be a bug report on this. The suggestion which worked for me was to set the default character set to Latin1 before exporting. Then when you import, tell mysql that the file you are importing is encoded as Latin1.

 

How do you set this?

In recent versions of phpmyadmin you can do this. Otherwise you may need to telnet in and use the unix command line.

Link to comment
Share on other sites

You need to set the default character set in mysql before you export if it hasn't already been set. If you don't do this your file will not be in any character set and the unusual characters will not be decoded on import into the new database.

 

If you read the mysql forums there appears to be a bug report on this. The suggestion which worked for me was to set the default character set to Latin1 before exporting. Then when you import, tell mysql that the file you are importing is encoded as Latin1.

 

How do you set this?

In recent versions of phpmyadmin you can do this. Otherwise you may need to telnet in and use the unix command line.

 

Cheers, I'll lool into this, may be re-copy the database with changes.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...