After importing into Discourse from a phpbb site I have strange characters in my posts


(Ben M) #1

For example I see

I’d

instead of

I’d

in the text of a post. I assume this is something like a ‘MS Word-style’ apostrophe in the original phpbb post. Any idea why my Discourse site isn’t displaying it correctly?


(Gerhard Schlager) #2

Looks like an encoding issue. What’s the collation and character set of your phpbb schema?
In case that it isn’t set to any kind of utf8 then you’ll probably have to convert it before the import.


(Ben M) #3

It looks like the phpbb database (which is an MS SQL database) is set to ‘SQL_Latin1_General_CP1_CI_AS’. Looks like I need to go and find out how to change that…


(Sam Saffron) #4

Seen this in the past with MySQL, looks like the importer should be forcing encoding. this is somewhat related Encoding problems in rails on ruby 1.9.1 - Stack Overflow