No Ä, Ö, Ü, etc. >>> Now it works
Thanks, for all the replays, now it´s ok. The problem was in the db.properties, there was an insert like this: db.connect.suffix="characterEncoding=iso-8859-2&useUnicode=true" it only works without the "": db.connect.suffix=characterEncoding=iso-8859-2&useUnicode=true Rainer Sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
No Ä, Ö, Ü, etc.
Thanks for all the replays, here are the details: The server is Windows 2000 with SP3 and the client is Windows XP Prof. The Frontend is written under Java and is a special programm for us. Here is my my.ini: #This File was made using the WinMySQLAdmin 1.4 Tool #04.12.2002 09:52:43 #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=P:/mysql bind-address=192.168.1.30 datadir=P:/mysql/data language=P:/mysql/share/german default-character-set=latin1_de #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=P:/mysql/bin/mysqld-nt.exe user= password= QueryInterval=10 [Client] character-sets-dir=P:/mysql/share/charsets default-character-set=latin1_de And my db.properties: # Eintrag in der Clusterresource java -server -Xmx128m -jar P:\resource\jar\joe.jar p:/cfg/cluster/ini/db.properties db joe.autostart=db # LOG4J Konfiguration include.lcf=/cfg/include/logcfg/DB.lcf # ENDE LOG4J Konfiguration xmlpath=/resource/xds;xml include.mcast=/cfg/cluster/ini/mcast.properties #onco.debug=0 # onco.sleep=5 db.prefix=/Service/db/my db.host=ELR1SRV db.definition=databases.xml db.connect.suffix="characterEncoding=iso-8859-1&useUnicode=true" # Polen: # db.connect.suffix="characterEncoding=iso-8859-2&useUnicode=true" joe.processname=Datenbank Server I hope somebody can help us !!! Here is the output of the command mysqladmin variables: mysqladmin: ERROR: unknown variable 'default-character-set=latin1_de' All 'ä', 'ö', 'ü', etc. are changing in ?,! What can I do against it? Rainer Sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: No Ä, Ö, Ü, etc.
On Mon, 9 Dec 2002, Sollinger Rainer (dienstlich) wrote: > All 'ä', 'ö', 'ü', etc. are changing in ?,! > > What can I do against it? Rainer, first of all: tell us about your setup. What is the output of: prompt> mysqladmin variables Then give an example how you populate your db with data and how you retrieve it. BTW: MySQL works fine for me wich character set 'latin1_de'. Thomas Spahni > Sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: No Ä, Ö, Ü, etc.
Hello. On Mon 2002-12-09 at 07:54:46 +0100, [EMAIL PROTECTED] wrote: > All 'ä', 'ö', 'ü', etc. are changing in ?,! Since MySQL simply stores what it is given, without interpreting charsets, this means that the input method/device you use and the output method/device disagree on the encoding. So this not really a MySQL issue in the sense that you quite probably have the same problem if you removed MySQL from the chain. > What can I do against it? Depends. You have given too few information as to make suggestions. How do you input data. How do you display it. On which software / OS runs the input resp. output part? And so on. HTH, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
No Ä, Ö, Ü, etc.
All 'ä', 'ö', 'ü', etc. are changing in ?,! What can I do against it? Rainer Sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
