[TYPO3-dev] Importing content using TCEMain -Text encoding

[Satish Maurya]

Thank you so much Andreas.
I used below code without making any changes in "pages" table. however,
pages table has Character Set  "latin1" and Collation is "latin1_swedish_ci"
//----------
$text = utf8_encode('Prozess- übersicht');
//------------
Its working. Great :)

Thanks again.


On Wed, Aug 27, 2014 at 11:33 AM, Andreas Fernandez <
andreas.fernandez at aspedia.de> wrote:

> Hi,
>
> either
>
>  $text = utf8_encode('Prozess- übersicht');
>>
> or
>
>> $text = utf8_decode('Prozess- übersicht');
>>
>
> But usually, this is not required. Please check the collation of the
> "pages" table, it should be "utf8_general_ci".
>
> Andreas
>
> Am 27.08.2014 07:15, schrieb Satish Maurya:
>
>  ​Thanks Andreas on reply.
>>
>> I want to write but not sure where/what should I write the code . do you
>> have any idea could you please suggest any single line code.
>>
>> Thanks
>>
>>
>> On Tue, Aug 26, 2014 at 7:54 PM, Andreas Fernandez <
>> andreas.fernandez at aspedia.de> wrote:
>>
>>  Hi,
>>>
>>> I don't know if there is "a TYPO3 way" but did you try to
>>> utf8_(de|en)code
>>> the $text?
>>>
>>> Mit freundlichen Grüßen,
>>> --
>>> Andreas Fernandez
>>>
>>> Am 26.08.2014 16:18, schrieb Satish Maurya:
>>>
>>>   Hello,
>>>
>>>> I am trying to import bulk data from external database to TYPO3 6.1
>>>> database using below script.
>>>> //------------------
>>>> <?php
>>>> define('TYPO3_PROCEED_IF_NO_USER', 1);
>>>> require 'init.php';
>>>>
>>>> $text = 'Prozess- übersicht';
>>>>    $data['pages']['NEW9823be87'] = array(
>>>>    'title' => $text,
>>>> 'subtitle' => 'Other title stuff',
>>>>    'hidden' => '0',
>>>> 'pid' => '-20'
>>>> );
>>>>
>>>> $tce =
>>>> \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance('
>>>> TYPO3\\CMS\\Core\\
>>>> DataHandling\\DataHandler');
>>>> $tce->stripslashes_values = 0;
>>>> $tce->start($data, array());
>>>> $tce->process_datamap();
>>>> ?>
>>>> ​//-------------------------​
>>>>
>>>> ​It gets added but page title gets converted in question mark in place
>>>> of
>>>> German text.
>>>> Text converts to " Prozess- ?bersicht"
>>>>
>>>> Could you please suggest any solution on this.
>>>>
>>>> Thanks​
>>>> _______________________________________________
>>>> TYPO3-dev mailing list
>>>> TYPO3-dev at lists.typo3.org
>>>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-dev
>>>>
>>>>  _______________________________________________
>>> TYPO3-dev mailing list
>>> TYPO3-dev at lists.typo3.org
>>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-dev
>>>
>>
>>
>>
>>
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-dev




-- 
*Thanks & regards,*
Satish Maurya