[Typo3] Did typo3 3.8 compatible to mysql 4.1??

[Dennis Cheung]

Hi Peter,

1) yes, they all are UTF8,
Server Character Set and
Collation<http://dev.mysql.com/doc/refman/5.0/en/charset-server.html>is
utf8
Database Character Set and
Collation<http://dev.mysql.com/doc/refman/5.0/en/charset-database.html>is
utf8
Table Character Set and
Collation<http://dev.mysql.com/doc/refman/5.0/en/charset-table.html>is
utf8
Column Character Set and
Collation<http://dev.mysql.com/doc/refman/5.0/en/charset-column.html>is
utf8

But, when I debug the connection with Connection Character Sets and
Collations <http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html>,

SELECT @CHARACTER_SET_CLIENT; is latin1

Whatever "default-character-set" is exists or not in my.cnf.
Typo3 should do
SET character_set_client = xxx;
SET character_set_results = xxx;
itself just after it get a new connection.

2) no, mbstring is not enabled.
and I am not going to recomile php.

My point of view is, it should not change many system/environment for a
single application.
It should do init for it's own working environment when it can.

Thanks,
Dennis

On 11/18/05, Peter Russ <peter.russ at 4many.net> wrote:
>
> Dennis Cheung wrote:
> > Hi Gideon,
> >
> > I was throught that is okay before. Some problem you will not notice
> until
> > you saw the error.
> >
> > for example. mysql 4.1 unicode compatible.
> > I didn't notice that before I saw some character broken.
> > And I found, mysqld using utf8, typo3 using utf8, but mysql_connect
> using
> > iso-8859-1.
> This is not a problem of TYPO3 but of your MYSQL/PHP setup:
> 1) check if all character_set_* at MYSQL are set to UTF-8
> 2) check which character encoding PHP uses. IS mbstring enabled?
>
> If you can't set this up correctly due to missing permissions you might
> want to change ISP with a correctly setup.
>
> Regs. Peter.
> --
> _____________________________
> 4Many(r) Services
> openBC: http://www.openbc.com/go/invuid/Peter_Russ
> _______________________________________________
> Typo3-english mailing list
> Typo3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>