Problem with charsets
Wim Stockman <wim.stockman <at> gmail.com>
2008-02-27 16:34:36 GMT
I'm creating a small program where I have to use an access database
My query is fine and runs but when I put the data out special french
characters are displayed incorrect does anyone now how to avoid this
thank you.
Here under you find what I do with my connection and my string. I
tried differt codepage setting but nothing worls , also tried to use
the php code utf8_decode but is even worse
:
$this->_db = ADONewConnection('ado_access');
$this->_db->Codepage = "utf8";
$this->_dsn =
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Documents and
Settings\All Users\Application Data\Adobe\Photoshop Album\Catalogs\My
Catalog.psa;Uid=;Pwd=;";
$this->_db->Connect($this->_dsn);
{
$rs = $this->_db->Execute('SELECT FolderTable.fFolderName,
ImageTable.fImageCaption, ImageTable.fMediaFullPath,
ImageLongCaptionTable.fImageLongCaption, ImageTable.fImageId
FROM ImageLongCaptionTable RIGHT JOIN ((PageTable INNER JOIN
ImageTable ON PageTable.fImageIdFromPage = ImageTable.fImageId) INNER
JOIN FolderTable ON PageTable.fFolderIdFromPage =
FolderTable.fFolderId) ON ImageLongCaptionTable.fImageLongCaptionId =
ImageTable.fImageLongCaptionIdFromImage;
' );
}
(Continue reading)