[TYPO3-mvc] Encoding problems

[Michael Knoll]

Hi there,

we are facing encoding problems when trying to import tags from image 
meta-data into our gallery. I copied a rather lengthy error message at 
the end of this post.

My question now is - can you tell me a save way to encode any input 
string we get (as we do not know, which encoding the tags in the meta 
data have) into UTF-8? Seems like this is a hard problem.

I know, this is not really Extbase related stuff, but there seem to be 
quite some skilled developers in this list so I tried to ask around here.


Any help would be greatly appreciated!


Greez

Mimi




Here comes the error message:

[Fri Jul 22 18:33:09 2011] [error] [client 192.168.1.100] Illegal mix of 
collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) 
for operation '=': SELECT tx_yag_domain_model_tag.* FROM 
tx_yag_domain_model_tag WHERE tx_yag_domain_model_tag.name = 
'Kletterhalle Karlsruhe Hebeb\xc2\x9fhne' AND 
tx_yag_domain_model_tag.deleted=0 AND tx_yag_domain_model_tag.hidden=0 
AND (tx_yag_domain_model_tag.starttime<=1311352380) AND 
(tx_yag_domain_model_tag.endtime=0 OR
tx_yag_domain_model_tag.endtime>1311352380) AND 
tx_yag_domain_model_tag.sys_language_uid IN (0,-1) AND 
tx_yag_domain_model_tag.pid IN (0) LIMIT 1 [Fri Jul 22 18:33:09 2011] 
[error] [client 192.168.1.100] #0
/var/www/kunden/yag-gallery.de/typo3/sysext/extbase/Classes/Persistence/Storage/Typo3DbBackend.php(239):
Tx_Extbase_Persistence_Storage_Typo3DbBackend->checkSqlErrors('SELECT
tx_yag_...')\n#1
/var/www/kunden/yag-gallery.de/typo3/sysext/extbase/Classes/Persistence/Backend.php(238):
Tx_Extbase_Persistence_Storage_Typo3DbBackend->getObjectDataByQuery(Object(Tx_Extbase_Persistence_Query))\n#2
/var/www/kunden/yag-gallery.de/typo3/sysext/extbase/Classes/Persistence/Manager.php(138):
Tx_Extbase_Persistence_Backend->getObjectDataByQuery(Object(Tx_Extbase_Persistence_Query))\n#3
/var/www/kunden/yag-gallery.de/typo3/sysext/extbase/Classes/Persistence/QueryResult.php(133):
Tx_Extbase_Persistence_Manager->getObjectDataByQuery(Object(Tx_Extbase_Persistence_Query))\n#4
/var/www/kunden/yag-gallery.de/typo3/sysext/extbase/Classes/Persistence/Repository.php(382):
Tx_Extbase_Persistence_QueryResult->getFirst()\n#5
/var/www/kunden/yag-gallery.de/typo3conf/ext/yag/Classes/Domain/Model/Item.php(684):
Tx_Extbase_Persistence_Repository->__call('findOneByName', Array)