[TYPO3-english] DBAL & PostgreSQL

[Rens Admiraal]

Hi all,

 

I installed TYPO3 4.3.2 with DBAL on PostgreSQL 8.4. Everything seems to be
working fine, but storing empty strings is causing troubles somehow. 

 

For example the subtitle field of the pages table. If I add a new page (with
empty subtitle), the subtitle is set to the value 'als'. Some debugging
learnt me that $fieldArray['subtitle'] is false in TCEMain::updateDB. This
causes t3lib_div::fullQuoteString to return 'als'. The error TYPO3 returns
is '102: These fields are not properly updated in database: (subtitle)
Probably value mismatch with fieldtype.' Which is good, because the stored
value doesn't match the given value.

 

This is my localconf config of dbal:

$TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array (

                '_DEFAULT' => array (

                               'type' => 'adodb',

                               'config' => array (

                                               'driver' => 'postgres8',

                                               'port' => 5432,

                                               'username' => 'user',

                                               'password' => 'password',

                                               'host' => 'localhost'

                               )

                )

);

 

I can't find anything regarding this problem in the documentation /
internet, do I forget something?

 

Greetz,

Rens