Hello,
I have a programmer in html / php. Under windows I have the correct display in IE / Firefox. Out in Paldo, there are two things that are different : In a MySQL (SQL) it shows me an error conflicts with the Swedish and utf8 in a query.

And also i download jedit4.3pre16.jar and installed jdk and jre but it don't seem to want to install....

Can you give me a solution ?

Thanks

Zitat

In a MySQL (SQL) it shows me an error conflicts with the Swedish and utf8 in a query

Can you post the error-message here?

Zitat

And also i download jedit4.3pre16.jar and installed jdk and jre but it don't seem to want to install....

What do you want to install?
 
..............................
https://www.richardnespithal.com
# [ ! $(uname -r | grep "paldo") ] && rm -rf /*

Zitat

Original erstellt: 2009-04-04 16:58 von ritchy What do you want to install?

Thanks for response.

I want to install jEdit. It is a program who can wrote php/html/js...

Thanks

Hello,

The error of my SQL query is :

L'envoi de la requête a echoué, la Base de donnée a répondu :
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'


And the SQL (into PHP script) :

$Query = "SELECT * FROM droits WHERE idrh='$idrh' AND module LIKE \"%".utf8_decode($item)."%\"";


It's a same problem with when i INSERT into a table the 'é', 'à', ..., are remplace by '?'.

Thanks

P.S. : The same script work perfectly into Debian or Ubuntu or Fedora.

we don't support Swedish as language yet. So also mysql dosn't have the support. In what language do you write?

Zitat

Original erstellt: 2009-04-04 22:28 von Amnon82 we don't support Swedish as language yet. So also mysql dosn't have the support. In what language do you write?

I wrote in PHP and I live in Paris (French)

well french is supported ...

check this out:

http://forums.mysql.com/read.php?26,6528,6528
http://www.experts-exchange.com/Database/MySQL/Q_22879585.html
http://www.phpbuilder.com/board/showthread.php?t=10350685
http://www.wallpaperama.com/forums/illegal-mix-of-collations-latin1-swedish-ci-implicit-and-utf8-general-ci-coercible-for-operation-t6895.html

Thanks. It means thats all my script can't work with paldo ?

Because I must havec latin1_swedish because in my server production is use it and now i can't change it....

Thanks