Re: [PHP] Encoding problem

2007-02-05 Thread Guus Ellenkamp
Found it. Have to use: mysql_query("SET CHARACTER SET 'utf8'", $link); ""Guus Ellenkamp"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > The document IS UTF-8. The character does not seem to be. It comes from a > mySQL database. However, also the database settings are also UTF-8.

Re: [PHP] Encoding problem

2007-02-05 Thread Guus Ellenkamp
The document IS UTF-8. The character does not seem to be. It comes from a mySQL database. However, also the database settings are also UTF-8. The field was entered into the database with phpMyAdmin. I tried it now local on my test-system and remote, so the database itself does not seem to be the

Re: [PHP] Encoding problem

2007-02-05 Thread Jon Anderson
Guus Ellenkamp wrote: I have a string with an n with a tilde. mb_detect_encoding says it's UTF-8. I set the http encoding to UTF-8 and also the internal encoding. However, I cannot produce proper output with echo $varwithtilde. echo $returnArray[$i]->address1.' has '.mb_detect_encoding($retu

[PHP] Encoding problem

2007-02-05 Thread Guus Ellenkamp
I have a string with an n with a tilde. mb_detect_encoding says it's UTF-8. I set the http encoding to UTF-8 and also the internal encoding. However, I cannot produce proper output with echo $varwithtilde. echo $returnArray[$i]->address1.' has '.mb_detect_encoding($returnArray[$i]->address1) d

[PHP] encoding problem when inserting into database

2006-04-28 Thread Zouari Fourat
Hello, Am having days trying to solve my problem : Using PostgreSQL database with server and client encoding set to utf8. I can enter any accentuated data on PHPPgAdmin interface and can see it stored like i entered it. The problem that when using a php script, it throw an error when trying to ins

[PHP] encoding problem

2004-01-03 Thread Pedro Salgueiro
Hi. I have made a script in php that calls a java program. This java program will make a connection to a PostgreSQL db and do some operations. That java program works just fine if I run it on a console, but when it is php to runing it, it gives some errors related to the charset encoding. The erro

[PHP] encoding problem

2003-12-27 Thread Pedro Salgueiro
Hi. I have made a script in php that calls a java program. This java program will make a connection to a PostgreSQL db and do some operations. That java program works just fine if I run it on a console, but when it is php to runing it, it gives some errors related to the charset encoding. The erro

[PHP] Encoding problem (french character) in txt file on Mac OS X

2003-09-10 Thread Thierry Santacana
Hi, I've tried several things but I can't get out of this issue ! I have this meta-tag in my header : When I write some strings with french accentuated characters in a .txt file with fwrite(), then when I open the file with SimpleText or TextEdit (Mac OS X 10.2) or even with pico and emacs, I

Re: [PHP] Encoding problem ONLY with _command line_ PHP.exe

2002-07-15 Thread Analysis & Solutions
On Fri, Jul 12, 2002 at 11:02:54PM +0100, Emile Axelrad wrote: > Hello - My problem is as follows (I am trying to migrate from a mssql > server to a mysql server) OH! > The data in the MSSQL table is: Æã > > IF I call this PHP code from my browser (IE6) it results in the > following output: Æ

[PHP] Encoding problem ONLY with _command line_ PHP.exe

2002-07-12 Thread Emile Axelrad
Hello - My problem is as follows (I am trying to migrate from a mssql server to a mysql server) The data in the MSSQL table is: Æã IF I call this PHP code from my browser (IE6) it results in the following output: Æã and it also places into the MySQL database the value: Æã However, if I

Re: [PHP] Encoding problem with command line PHP.exe

2002-07-12 Thread Analysis & Solutions
Emile: On Fri, Jul 12, 2002 at 09:58:53PM +0100, Emile Axelrad wrote: > $data = mssql_result(mssql_query("SELECT Field FROM table WHERE > ID='1'"),0); > mysql_insert("INSERT INTO table2 VALUES('$data')"); Ouch. First, you're mixing and matching mssql and mysql functions. Seco

[PHP] Encoding problem with command line PHP.exe

2002-07-12 Thread Emile Axelrad
Hello - My problem is as follows: The data in the MSSQL table is: Æã IF I call this PHP code from my browser (IE6) it results in the following output: Æã and it also places into the MySQL database the value: Æã However, if I call this PHP code from the command line, using "php.exe tes

[PHP] Encoding problem with command line PHP.exe

2002-07-12 Thread Emile Axelrad
Hello - My problem is as follows: The data in the MSSQL table is: Æã IF I call this PHP code from my browser (IE6) it results in the following output: Æã and it also places into the MySQL database the value: Æã However, if I call this PHP code from the command line, using "php.exe tes