problem with charsets mssql/mysql php

From: Date: Tue, 04 Feb 2003 12:35:20 +0000
Subject: problem with charsets mssql/mysql php
Groups: php.db 
Request: Send a blank email to php-db+get-25405@lists.php.net to get a copy of this message
Hi, This is the problem I am having: I have to extract data from MS SQL into MY SQL using PHP. The MS SQL (puke!) runs on a (yuck!) MS Small Business Server. It contains text fields that contain text with characters like ë, ö, é, è (Dutch language). The MY SQL used to run on Windows 2000. The strings that were read from the MS SQL and put into the MY SQL were identical. Due to a security leak (hah) I installed OpenBSD on the same machine, used be-latin1 local settings. I also managed to get MYSQL working under OpenBSD. The problem is now... when i insert something like this into the mysql: insert into table(field) values("This is a test. ë."); and i want to output that string from the MYSQL running on OpenBSD, i get this: "This is a test. ?." so you see the weird character in stead of the ë. How can i resolve this quickly? Thank you for the help ! Kind regards, Filip

« previous php.db (#25405) next »