Client characterset ändern

MySQL, PostgreSQL, SQLite
druschl
Posts: 15
Joined: 2005-02-03 12:25

Client characterset ändern

Post by druschl » 2005-10-24 13:53

Hallo.

bekomme bei der Ausgabe von s auf der mysql Konsole:

--------------
mysql Ver 14.7 Distrib 4.1.12, for pc-linux-gnu (i686) using readline 4.3

Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: less
Using outfile: ''
Using delimiter: ;
Server version: 4.1.14-log
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 12 sec

Threads: 1 Questions: 3 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.250
--------------


Wie kann ich nun
Client characterset: latin1
Conn. characterset: latin1

auf UTF-8 ändern ?

Gruss
Tom

User avatar
Joe User
Project Manager
Project Manager
Posts: 11137
Joined: 2003-02-27 01:00
Location: Hamburg

Re: Client characterset ändern

Post by Joe User » 2005-10-24 13:58

Doku lesen und my.cnf anpassen.
PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings for Life World Run

„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.