problem with charsets mssql/mysql php
| From: | Filip De Graeve | 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