Special characters break when locks released

Squiz Matrix Support
1

I have a Standard Page on which I am trying to insert the pound symbol. I've used both the Insert Special Character button in the WYSIWYG and pasted £ in the code.


Upon commiting it displays the pound symbol fine but when I release the locks it reverts to ??



Is this the charcter set we are using? (UTF-8)

Or something else?



Thanks,

Sarah

2

Which version of Matrix? There was a typo in the html_tidy.inc file that prevents tidy from preserving entities. This could also be caused by Oracle not being in UTF-8 mode.
3

Matrix 3.14.3

I'll check with our DBAs if Oracle is in UTF-8 mode

Thanks :)
4

The related fix: bug #2625.
Also note that you will have to update tidy binary to at least 11 February 2007 release to use this new option. You can find out the version by running “tidy -v”.

5

We did some testing with 10g here and found that you need to set the encoding correct on both the server and the client.

To get it working, you need to make sure the NLS_CHARACERSET in Oracle is set to AL32UTF8 and also that an NLS_LANG environment variable is set for the Apache user with the value ".AL32UTF8" (note the dot at the front).

I assume your DB was created with AL32UTF8 as the charset, so you'll just need to set an environment variable for the user Apache is running as.
6

its being 2 years and now this bug has resurfaced again in the 3.20.6 again


our database is on the UTF-8,as well as our apache configuration



cheers :rolleyes:

7

[quote]
its being 2 years and now this bug has resurfaced again in the 3.20.6 again



our database is on the UTF-8,as well as our apache configuration

[/quote]

In our PHP 5 releases there is an option to include the character encoding for Oracle in the db.inc configuration file.

The database connection may not be established under the right encoding to match the content.

8

Is it possible to give us an example how the db.inc information should look like to resolve this matter would be greatly appreciated


cheers :unsure:

9

[quote]
Is it possible to give us an example how the db.inc information should look like to resolve this matter would be greatly appreciated

[/quote]



An example and explaination of db.inc can be found on the annotated db.inc page here



HTH