Accent (yes I know)

[Dom]

Hello

First of all I'd read previous posts ans I know you're tired about this problem.

PixelPost 1.5 - April 2006
PHP-version 4.4.2-0.dotdeb.1
MySQL version 4.0.24_Debian-10sarge1-log
All directories OK

I just installed a new pixelpostpost blog with the pixelpost1-5rc1-2.zip file. So the problem concern new comments, no comments from previuos versions.

I test with PC running windows, PC running Linux (Fedora flavour) and Mac ppc running macosx.

When I insert a comment with accent after closing the comment window, looking at the comment accents are replaced with other signs.

With same operating systems and browsers, If I go directly to mysql db without using Pixelpost, and modify the comment in the table, ie: apending on the same record and line, the same comment with the same accents, when I use Pixelpost to view the result of the modification through the comment window, the original comment still has garbage as previous but the new appended text displays correctly.

Clearly the display routines for the comments works well, but it seems there is a problem with the insert one.

Could somebody explain me clearly (please) what I'm doing wrong or if it's a bug (possibly an old one back again)

Thanks

Dom

[fofie]

Hi Dom;
Same for me with 1.5. Accents in comments are replaced by question marks.
Anyone can help?
Thanks!

[GeoS]

Check if your browsers encoding is set to UTF-8, if template is with UTF-8 and if form has got UTF-8.

[fofie]

Well, I've checked the template and it is set to UTF-8... my brower is set to UTF-8 too. But, the form, I couldn't find... Well, I have a form.htm in my root directory but I think it's not valid... anyway, I changed the encoding in it to UTF-8 and nothing changed with the comments.

[Dom]

Ok. After extensive tests with various flavours of windows and macos X (I didn't use linux for this tests), changing from iso-8859-1 to utf-8 back and forth, do not change the result. I'd tried all in utf-8, all in iso-8859-1 and even mixing all that! Absolutely no difference. If I use ie all seems ok. But if I use firefox (windows and mac), opera or safari what is inserted directly in mysql table or with ie displays correctly, but what is inserted with these 3 browsers displays wrong, not only with those browsers but also with ie.

I still think there is a problem in the insert routine. IE can cope with it but the other browsers don't!
I cannot be sure which browser the visitor will use.

Be confident that I checked more than once, all (browser, templates) be in utf-8.

Thanks

Dom

[Dom]

This problem arises not only in comments but also in images' legends

[Connie]

in all these steps, the basic configuration of the MYSQL-Database is not listed

what is the characterset of your database?
you can find out that with PHPMyadmin, (check out "Localhost / Databases / Variables / character set)

there can also be potential for strange results

[fofie]

thanks dom and connie. i checked mysql and 'utf-8 general' was selected, among others. i also checked on IE and the signs were worse in the comments for me, really a mess!

[Dom]

The database is latin1. I'm, as most user are, dependent on the hosting service in database creation and the only thing under control is the name of de db. I can't use "alter database" this features doesn't exist before v4.1. I can and I did "alter table T character set utf8", but it doesn't change anything.

Any solution?

Thanks a lot for you help

Dom

[olive]

I have this problem too...I hope that you will find a solution...in fact I'm sure that you will find... ;)